This is called a Group_Concat in MySQL. SQL Server does not provide such functionality. It has to be mimicked with the @var method you describe.

Here is a similar article...

Adding the three properties suggested above has worked for me in the past, but it didn't work this time, when I had a Column Group in my Header.

I added a...

Lawrence/Eric:

You guys are right. Thanks for pointing that out to me.

I use system tables to see if the table has been updated:

SELECT @expiration_dt = [modify_date]

FROM [mydb].[sys].[tables]

WHERE [name] = 'mytable'

If I detect @expiration_dt to be newer than my stored data...

Good article. I come from an application environment where I had more flexibility to use outside coding. I'm happy to see we can do interesting things while still in the...