Viewing 5 posts - 1 through 5 (of 5 total)
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...
September 28, 2012 at 7:46 am
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...
January 30, 2012 at 6:35 pm
Lawrence/Eric:
You guys are right. Thanks for pointing that out to me.
May 23, 2011 at 3:05 pm
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...
May 23, 2011 at 10:48 am
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...
May 2, 2011 at 10:43 am
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy