Hi all,

Over the weekend I tried to write a stored procedure that included Select... Into, Alter Table, and Update statements.

I tried adding GO after each statement and that worked fine in the query analyzer. I tried copy and pasting the statements into the stored procedure and it only saves the first statement before the first GO.

Next I tried deleting the GO statements, but then the alter statements do not work.

Do I need to put the Alter Table and Update statements in separate stored procedures or is there any way around it?

Thanks,
JazzBass