Tuesday, December 2, 2014

Stored Procedure Performance when passing in mutli-values from a SSRS Report

I'm using following method:


In SSRS values are represented as XML nodes:


<node value=19\>


<node value=62\>


All the selected nodes then passed to stored procedure as a single string, which is XML document.


<param><node value=19\><node value=62\><\param>


Standard XML shredder in TSQL converts it to a table in no time.


You may also consider storing separated values in a temp table instead of using UDF in the query.


No comments:

Post a Comment