Thank you Borislav. That was exactly what I needed!
>>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??
>>>>
>
>Something like this:
>
>CREATE TABLE #Temp (field list here as your SP expect)
>EXEC YourSP ....
>SELECT * from #Temp
>DROP TABLE #Temp
>
>
>ALTER PROCEDURE YourSP (....)
>AS
>BEGIN
> INSERT INTO #Temp VALUES (.......)
>END
>
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.