Converting multiple values in form of comma separated string

[kuchel]

Hi
I have a table which looks typically like this:-
ColA COLB
2370 2875
2370 3194
2376 3108
2417 2437
2539 2774
2539 2732
2539 3240

AS you can see from above ColB has repeated values. Fro example 2370 has 2875 and 3194 in ColB
What I am trying to do is

ColA COLB
2370 2875,3194
2376 3108
2417 2437
2539 2774,2732,3240

Can somebody guide me please
Cheers

[azimmer]

Hi
I have a table which looks typically like this:-
ColA COLB
2370 2875
2370 3194
2376 3108
2417 2437
2539 2774
2539 2732
2539 3240

AS you can see from above ColB has repeated values. Fro example 2370 has 2875 and 3194 in ColB
What I am trying to do is

ColA COLB
2370 2875,3194
2376 3108
2417 2437
2539 2774,2732,3240

Can somebody guide me please
Cheers

Here it goes, polish if you like (input table is Test, output goes to TestOut (int,varchar(255)):

declare @colA as int, @newcolA as int, @colB as int
declare @newcolB as varchar(255)
declare crsr cursor for select colA, colB from Test order by colA
open crsr
fetch next from crsr into @newcolA, @colB
set @colA=@newcolA-1
set @newcolB=''
while @@FETCH_STATUS=0
begin
    if (@colA = @newcolA)
    begin
        set @newcolB = @newcolB + ',' + cast(@colB as varchar)
    end
    else
    begin
        if (@newcolB<>'') insert into TestOut values (@colA,@newcolB)
        set @newcolB = cast(@colB as varchar)
        set @colA = @newcolA
    end
    fetch next from crsr into @newcolA, @colB
end
if (@newcolB<>'') insert into TestOut values (@colA,@newcolB)
close crsr
deallocate crsr
 

[kuchel]

thanks azimmer
I appreciate that.
Cheers,