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