Concatenating rows

We decided to use the data driven subscriptions for SSRS. This means storing all kinds of info in a database and then having to present it to the report server as subscription parameters. Specifically we have to concatenate a bunch of emails representing subscribers into a single email column which is then mapped for a data driven subscription. I did this using CTEs. I saw a bunch of examples but this site had them all in one handy place.

This entry was posted in SQL, SSRS and tagged . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *