Extracting XML from another stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Extracting XML from another stored procedure

Author

Topic

shabazz5th
Starting Member

13 Posts

Posted - 2008-11-11 : 11:57:52

Hey guys,

I posted this question incorrectly in the SQL2005 forums, thought I'd try it here.

I have a stored procedure that generates xml using XML Auto...I want to run another stored procedure immediately afterwards and use those results (XML,) from the first one and feed it into the second one.

ie.

exec XMLGenerate (this creates the xml)
exec CalculateOrder var1, var2, var3 (these variables are from the xml generated in the first one).

Thoughts?

Thanks,

cvraghu
Posting Yak Master

187 Posts

Posted - 2008-11-12 : 00:27:12

Duplicate. Already being helped in other thread -
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=114166