01-07-2013 07:18 AM - edited 03-14-2019 11:04 AM
I am trying to create a report that shows reason codes as words, eg 1 =meeting etc
I have made what I believe to be the relavant changes, however whilst the Parameters check out ok, when i go to creat the fields, I get a syntax error.
if anyone can take a look at this and let me know here I am goiing wrong, I would be grateful.
please be advised, I haven't had any training on SQL, I am learning as i go!
01-07-2013 08:17 AM
Hi,
well, a syntax error is a syntax error, you must have a typo or something like that.
Did you try running your SQL query against the database (using a client like SQL whatever Studio)?
G.
01-07-2013 08:36 AM
Thanks for getting back to me, unfortunately I don't have the ability to check this through an SQL application.
Hence the question.:-)
I will go through the query again
Cheers Sarah
01-07-2013 02:57 PM
Wow. Are you modifying SQL queries without trying them out first? Well, that's the spirit
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide