Home Dashboard Directory Help

SQL needs version of MySQL group_Concat function by andy912300


 as Postponed Help for as Postponed

Sign in
to vote
Type: Suggestion
ID: 247118
Opened: 12/20/2006 10:45:57 AM
Access Restriction: Public


The pivot, ranking and numbering T-SQL enhancements are excellent. However, mySQL has one useful command that MS SQL does not -- GROUP CONCATENATE. During a GROUP BY, GROUP_CONCAT is similar to SUM except it concatenates all the combinations of the particular field for a particular aggregation. The coding workaround is a pain.
Sign in to post a comment.
Posted by Dave_Ballantyne on 6/5/2013 at 11:08 PM
I have to agree that this it is high time this very common functionality is developed.
Even the most cursory glance through online forums would reveal how often the workaround methods are used and required.
Posted by SQLSmallTalk on 2/22/2013 at 6:09 PM
This request was in 2006, plenty of time to have added it by now. The workarounds are very clunky
Posted by BroGuyMan on 2/28/2012 at 8:44 AM
Please add this to SQL Server. This would save time and also eliminate the need for bulky and complex work-arounds to express a simple and common need.
Posted by Microsoft on 1/4/2007 at 12:29 PM
Thanks for raising this suggestion. I agree this would be a useful intrinsic. While it does not make the bar for SP2, we're tracking it for future release of SQL Server.

Tomer Verona
SQL Server Development
Sign in to post a workaround.