#sql-server-group-concat

[goodanswerbiz]

Answer: How to use GROUP BY to concatenate strings in SQL Server? #computers #dev #development

Answer: How to use GROUP BY to concatenate strings in SQL Server? #computers #dev #development

How to use GROUP BY to concatenate strings in SQL Server?

How do I get:

id Name Value 1 A 4 1 B 8 2 C 9

to

id Column 1 A:4, B:8 2 C:9

Answer [by Dana the Sane]: How to use GROUP BY to concatenate strings in SQL Server?

I’ve looked for ways to do this before, and besides writing a stored proc, there isn’t an easy way to do it. I resort to writing a script or using an ETL tool like Talend to do…

View On WordPress

[goodanswerbiz]

Solution: Simulating group_concat MySQL function in SQL Server? #programming #it #answer

Solution: Simulating group_concat MySQL function in SQL Server? #programming #it #answer

Simulating group_concat MySQL function in SQL Server?

I’m trying to migrate a MySQL-based app over to Microsoft SQL Server 2005 (not by choice, but that’s life).

In the original app, we used almost entirely ANSI-SQL compliant statements, with one significant exception we used MySQL’s group_concat function fairly frequently.

group_concat, by the way, does this: given a table of, say, employee…

View On WordPress

[sevennet-blog]

How to: How to use GROUP BY to concatenate strings in SQL Server?

How to: How to use GROUP BY to concatenate strings in SQL Server?

How to use GROUP BY to concatenate strings in SQL Server?

How do I get:

id Name Value 1 A 4 1 B 8 2 C 9

to

id Column 1 A:4, B:8 2 C:9

Answer: How to use GROUP BY to concatenate strings in SQL Server?

I’ve looked for ways to do this before, and besides writing a stored proc, there isn’t an easy way to do it. I resort to writing a script or using an ETL tool like Talend to do this.

Answer: How…

View On WordPress

[sevennet-blog]

How to: Simulating group_concat MySQL function in Microsoft SQL Server 2005?

How to: Simulating group_concat MySQL function in Microsoft SQL Server 2005?

Simulating group_concat MySQL function in Microsoft SQL Server 2005?

I’m trying to migrate a MySQL-based app over to Microsoft SQL Server 2005 (not by choice, but that’s life).

In the original app, we used almost entirely ANSI-SQL compliant statements, with one significant exception we used MySQL’s group_concat function fairly frequently.

group_concat, by the way, does this: given a table of,…

View On WordPress