Any anyone point me to a example of a sproc that wraps another sproc and returns xml?
I cant figure out how to make one myself ;(
eg.
say i have a sproc called 'sp_GetAlbumsByArtist' and it has one parameter called 'ArtistID'
What i want to be able to do is pass this to another sproc eg... sp_GetXml [procname] [param] and it return xml.
If this is possible could it work with n parameters?
