I am still getting to grips with SQLA/ISQL so I know this might be a rookie error, but any help would be great.
Below is my code
The error I am getting is @prod cannot be found. Now I understand that I am not declaring a variable at this point, but if I run the following command
It executes with no errors, but no file is output.
asked 10 Jun '16, 11:54
Looks like a cross between TSQL and ANSI SQL try this although I haven't tested it...
answered 10 Jun '16, 14:29