clayman (5/12/2013)
Got it right finally. Maybe not the best solution but here's what I did. Split up both the input SSRS string and the "Paratype" strings, joined the two result set and finally concatenated the types so that they look "Type1, Type2, Type3" on the report itself.
This is going to get very unwieldy if your table gets much bigger than a few thousand rows (even then, it might bog down quite a bit). If it's possible for you to change the table definition to avoid storing multiple comma-delimited values in a single column, I would suggest that rather than splitting the comma-delimited values for EVERY row every time you run this query.
Jason Wolfkill