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