Thursday 4 October 2007

SQL Server : How to simulate the GROUP_CONCAT function

there is no groupconcat in sql server (only available in Mysql), but could be made using the example in the link below

Click the link

SQL Server : How to simulate the GROUP_CONCAT function
Posted by at

1 comment:

Kashif said...

DECLARE @x varchar(8000)
SELECT @x = COALESCE(@x+', ','')+ISNULL(GROUPNAME,'') FROM [whims2].[dbo].[UM_TGROUP]
SELECT @x

11 July 2011 at 21:35

Post a Comment

Subscribe to: Post Comments (Atom)