I added the INTO to the statement, but I get the exact same error. I only omitted it because I had seen some examples where it was not used.

I'll...

When I call this sp in SQL Query Analyzer I get the following:

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'temp_2_99'.

temp_2_99 is the table name...

Here is the stored procedure giving me the problem. Check out the condition where @numcols = 9. I am executing a RPC that returns 9 fields, it creates...