July 11, 2002 at 2:08 pm
Hi everybody. I have an interesting problem: How to concatenate XML streams? The idea behind this is: I have a stored procedure that returns a XML stream (using the estatement "FOR XML") containing application state information, and other stored procedure that returns a XML stream containing information used in a HTML form. Obviously, I want to write once the stored procedure for the application state and reuse it over and over; and, not so obviously, I want to receive just one XML stream with my ADO object. How can I concatenate those two streams (stored procedure results) and return them to my ADO object as one stream?
July 15, 2002 at 7:11 am
What about using a table function for your application state and UNIONing it into the the query that returns the rest of the query?
-Mike
Michael Levy
Michael Levy
ma_levy@hotmail.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply