SQL needs version of MySQL group_Concat function - by andy912300

Status : 

  Postponed<br /><br />
		Due to current priorities, the product team decided to postpone the resolution of this item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 247118 Comments
Status Closed Workarounds
Type Suggestion Repros 3
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 Igor Merabishvili on 7/17/2014 at 1:22 AM
Please add this functionality to SQL server. Looks like since 2007 nobody cares about it at Microsoft team.
Can this suggestion be reopend?
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