I have a stored procedure that takes a single parameter of data-type XML.I also have a table that has XML samples which I'd like to test as the parameter for this procedure.Is it possible to exec the SP and pass the result of a query on the test table as the XML input parameter? What would the syntax be?
Use query result as parameter to stored procedure in SSMS
- Thread starter shahjee99
- Start date