hansimglück
New Member
I have a stored procedure that can NOT be modified, the result of this stored procedure is normal select statement as following :\[code\]CREATE PROCEDURE LockedProcedureASBEGIN SELECT * FROM COLORS_TABLEEND\[/code\]my problem is that I need to get its result as XML result like how the select statement returns when you provide "FOR XML" but without modifying the procedure itself, maybe we can create another stored procedure to call that or user defined function. This is an example of the procedure that we CAN NOT modify because it is locked.how to get its result as XML result NOT XML FILE...I don't want any physical file on hard disk.Thanks.