question

siugoalie78 avatar image
siugoalie78 asked

Split CSV from SSRS

I have a multi-valued parameter in SSMS where in need to get the individual parameter values into a table. However, the syntax in which SSMS crates the parameter is something like " N'VALUEA',N'VALUEB'... So, SQL sees it as a list of several smaller strings, at least that is what it looks like when I capture it in the profiler. So, using a normal Split function does not work to break it up into a table. I need suggestions on how to accomplish this. Many thanks.
ssrs-2008-r2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·
Could you post an example output? This sounds like a case for DelimitedSplit8k ( http://www.sqlservercentral.com/articles/Tally+Table/72993/) but without seeing you output I cannot confirm
2 Likes 2 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.