I have a script that creates a report. It is a series of about 10 select statements all compiled in a text file. I simply open it up and run it in query analyzer.
The select statements create #Temp tables and then then next select statement will use that newly created #Temp table.
SELECT TOP 100
When I run something like this in query analyzer, I need to include the word 'GO' so that the prior statements finish running before they are used. I am now trying to make this script a stored procedure but am getting errors from the 'GO' statements.
Any thoughts ....