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.