Hi

I have two stored procedures:
SP1: returns an XML:
SELECT ColA,ColB FROM MyTable FOR XML RAW

SP2: Calls SP1

Is there a way SP2 can use the XML retuned by SP1?

Thanks