lmu92 (6/14/2010)
I'd also recommend you change the structure of your procedure names:it's considered as bad practice to start your stored procedures with sp_ since SQL server will try to find those sp's in master DB first (unless the proc is fully qualified or in a schema other than dbo).
This may cause unintended results. If you ever decide to name a proc "sp_addtype" that is used to add a specific type of area you'll see what I mean... 😉
Thanks, I'm aware though. This is just for demostrative purposes.
I just want to know about using a real table or passing a temp table. And issues I'll run into when more than one instance of this SP is called.