Simulate MySql group_concat in MSSQL

Asked Feb 04 '14 at 18:26

Active Feb 04 '14 at 18:26

Viewed 34 times

I want to run this MySql query in MSSQL.

Is there any possibility to achieve that, by modifying this query?

Select 

sku, 
(select group_concat(sku separator ",") 
from catalog_product_entity as _e 
where _e.entity_id in (select product_id from catalog_product_super_link as 
superlink where e.entity_id = superlink.parent_id))

from catalog_product_entity  as e
where type_id = "configurable"

group by sku

asked Feb 04 '14 at 18:26

Xhevat Ziberi

1

http://stackoverflow.com/questions/8868604/sql-group-concat-function-in-sql-server – Feb 04 '14 at 18:32
You have the choice of a CLR function, or a rather ugly SQL FOR XML: http://davidduffett.net/post/5334646215/get-a-comma-separated-list-of-values-in-sql-with-for – Michael Dunlap Feb 04 '14 at 18:32
@DigitalD rather ugly? I think it's the best performing option. – Hart CO Feb 04 '14 at 18:35
1

@GoatCO I meant that it just isn't as elegant as a function like `group_concat`, not that it doesn't perform well. – Michael Dunlap Feb 04 '14 at 18:36
I guess I will try with XML, as it looks easy. Thanks – Xhevat Ziberi Feb 04 '14 at 18:40
@DigitalD That's fair. – Hart CO Feb 04 '14 at 18:44

Simulate MySql group_concat in MSSQL

0 Answers0