Home > SQL Server > Comma separated list from mapping table as an embedded SELECT statement

Comma separated list from mapping table as an embedded SELECT statement

T-SQLEver needed to get a comma seperated list instead of another mapping table? Well in these days of Linq this may be old hat – but it’s still nice to remember how to do it. Here’s a quick and easy way to get a list from a linked table constructing the list field using the XML PATH features of SQL Server 2005:

 

(SELECT CAST(CountryId AS NVARCHAR(10)) + ‘,’ AS [text()]
     FROM UserToCountryMapping AS utcm
    WHERE utcm.UserId = externalSelectTable.UserId
     FOR XML PATH(”)) as Regions

Advertisements
Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: