Passing Parameters in Stored Procedures- SQl 2000

[Amit Deshpande]

Problem Definition: Stored Procedure SP1 calls Stored Procedure SP2. SP2 fires
a select query which uses the "for xml" clause. The result of this query
has to be passed back to the calling Stored Procedure i.i SP1.How??

[DaveSatz]

I am not too familiar with the XML stuff in SQL Server, but normally you can
do:
1. create temp table and then insert into temp table EXEC sp
2. you can have the 2nd SP be a UDF and have it return the XML as a table
variable maybe
--

HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
-----------------------------------------------------------------

"Amit Deshpande" <contact_amit@yahoo.com> wrote in message
news:3c0cbe33$1@147.208.176.211...
>
> Problem Definition: Stored Procedure SP1 calls Stored Procedure SP2. SP2
fires
> a select query which uses the "for xml" clause. The result of this query
> has to be passed back to the calling Stored Procedure i.i SP1.How??