Solved

Problems altering a complex SQL code, always get an error

Posted on 2008-10-08
2
161 Views
Last Modified: 2012-05-05
Hello,

Will be a mircale if someone could help with this one, been driving me crazy all afternoon. I'm trying to extend someones SQL code who has now left the business. I have attached the script to the thread in notepad. The problem I have is if I change the smallest thing like the output in an iif statement I get an error message which I have attached. Even if I put the script back to how it was and try and run it again I still get the same error message.

Does anyone know why it is happening? not expecting you to know what the script is fully doing just how I can correct the error or avoid it.

Finishing work now but back 8am GMT time, would be great is anyone has any ideas

Thanks
Ian
SQL.txt
error.JPG
0
Comment
Question by:ShockUK
2 Comments
 
LVL 8

Accepted Solution

by:
mikainz earned 500 total points
ID: 22670495
Hi please
replace the brackets [ and ]
with the following brackets ( and )

see attached file
sql2.txt
0
 

Author Closing Comment

by:ShockUK
ID: 31504254
So simple but so great.
I would give you more than 500 points if I could for this

Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question