The stored procedure that I attached was running fine until I added the last two queries to the CT section. The addition in for Bell Nursery. When I add the queries I get “Incorrect Syntax near the keyword ‘Union’ “, when I try to compile the SP.
The only way to get read of the error in to comment ( as I did ) the new addition.
Is there a limit on the number of Unions I can use in a SP?