concatinate ids

Question

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

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

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Hi

declare @var varchar(100)

set @var = ''

select @var = @var + cast(col1 as varchar(3)) + ',' from table

-- to remove the trailing comma

set @var = left(@var ,(len(@var )-1))

select @var

"Keep Trying"

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

N 56°04'39.16"
E 12°55'05.25"

Charbel-371270 SSCrazy Points: 2260 More actions · Answer 3

i use this:

CREATE

FUNCTION [dbo].[GetList]()

RETURNS

Varchar(20)

AS

BEGIN

DECLARE

@Result Varchar(20)

SELECT

@Result = Coalesce(@Result + ',', '') + ID

From tablename

RETURN ( @Result )

END

If something's hard to do, then it's not worth doing.

Amit Jethva SSCarpal Tunnel Points: 4707 More actions · Answer 4

SQL 2005 - XML way

select col1, stuff( ( select ','+ col2

from tab1 t1

where t2.col1 = t1.col1

for xml path('')

),1,1,'')

from tab1 t2

group by col1

order by col1

"There is no 'patch' for stupidity."