create table #temptable

Re: Fastest method for union of two selects Thread #1171624 Message #1172282

http://www.sql-server-performance.com/rd_temp_tables.asp

http://www.sqlservercentral.com/columnists/dasanka/temptablesinsqlserver.asp

>Please forgive my lack here. I have not used this method and I guess I am getting poor at looking up things in BOL. I was wondering what would be the syntax??
>
>Your help is very appriciated. :)
>
>>You can use a temp table. It'll be visible in the called SP.
>>
>>>Is there a way to pass tabular data from one procedure to another??
>>>