combine resultset values to one

Question

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Check out this article:

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 2

HI There,

I just learnt this today.

[Code]

DECLARE @Result VARCHAR(1000)

SELECT @Result = Col1 + ',' + ISNULL(@Result ,'')

FROM YouTable

SELECT @Result

[/code]

Hope that helps

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

MJ-727860 SSC Veteran Points: 202 More actions · Answer 3

MJ-727860

SSC Veteran

Points: 202

August 28, 2008 at 10:30 am

OMG thank you so much! 😀