>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
