DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

3
Shouts

Shout it

SQL Concatenation - Get column values as comma seperated list using XML PATH() instead of UDF's using COALESCE

published 1080 days, 3 hours, 11 minutes ago posted by

tsql 1081 days, 2 hours, 19 minutes ago

SQL Concatenation - Get column values as comma seperated list using XML PATH() instead of UDF's using SQL COALESCE

In my projects I frequently need sql string concatenation to get a list of column values of a table which may be called as child just as a column of a parent record which can be simply solved as sql concatenation methods. In this case it is possible to solve this t-sql concatenate problem by creating a udf (Used Defined Function). We can select the parent rows, and as an additional column in the select we can call the udf function which gathers and concatenate string in sql the child values as comma or semicolon seperated scalar value.

category: Data | clicked: 1 | | source: www.kodyaz.com | show counter code

tags: sql tsql concatenate xml

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

DotNetShoutout

Welcome!

SQL Concatenation - Get column values as comma seperated list using XML PATH() instead of UDF's using COALESCE

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up