Jim Russell (3/11/2008)
Great suggestion Jeff!I don't suppose I can prefix the temp procedure name with a '#', so my "main" will need to drop it when done?
Temporary stored procedures begin with a "#" and are treated the same way as Temp Tables so far as scope goes...
--Jeff Moden
Change is inevitable... Change for the better is not.