View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 01:54 PM
Hennie7863
 
Posts: n/a
Default Concatenating strings from different rows

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

Reply With Quote