Build string from table data

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

BEGIN TRAN

--Build sample data in TEST table

SELECT col1

INTO TEST

FROM (VALUES('STYLE'),('HK82382'),('HK82386'),

('HK84174'),('HK86190'),('HK87143'),

('HK87164'))a(col1);

--Actual solution starts here

DECLARE @StylesSelected VARCHAR(MAX);

SELECT @StylesSelected = STUFF((SELECT ',' + col1

FROM TEST

FOR XML PATH('')),1,1,'');

PRINT @StylesSelected;

ROLLBACK

PRINT @StylesSelected returns: -

STYLE,HK82382,HK82386,HK84174,HK86190,HK87143,HK87164

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

I don't see any need for dynamic sql here. What about just using IN?

where ITEMMAST.STYLE in (Select STYLE from TEST)

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

JayWinter Right there with Babe Points: 769 More actions · Answer 3

I knew there had to be a better way other than complicating the script with dynamic sql.

Thank you.