Posted by Hennie7863 on 11/14/05 16:45

Hi,

I have table which has the following values :

ID SEQ Text
1 1 A
2 1 B
3 2 C
4 2 D
5 2 E
6 2 F
7 3 G

The result should be :

1 AB
2 CDEF
3 G

Could somebody help me with this? I could use an cursor but the table
could be large and i want a fast solution.

Thanx in advance...

Hennie

• Next in forum: Re: Need security advice on xp_cmdshell, bcp, xml procedure
• Prev in forum: Re: SQL Join with unknown tables - but it works!?!
• Thread view: Concatenating strings from different rows

[Reply to this message]