IF object_id('tempdb..#Temp01') IS NOT NULL
	DROP TABLE #Temp01'
...
SELECT * INTO #Temp01'		
	FROM mytable 

EXEC My OtherSP
...
IF object_id('tempdb..#Temp01') IS NOT NULL
	DROP TABLE #Temp01'

>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??
>>>