Hello,

I have a stored procedure A whcih uses a FOR XML clause in it's select statement.
Now I want to call this procedure A from another stored procedure B. how should i do this. How can I ge hold of the xml that proc A returned in proc B.

Thanks,
JCMehta.