Concatenate content into one column 1

[yan19454]

I have the following info.

I need to update table OutPatientMedStat

from those records
PNO CPTCode
40000028 80061
40000028 83735
40000028 84100
40000028 84436
40000028 84443
40000028 84479
40000028 84480
40000028 85025
40000028 86617
40000028 86618
40000027 86617
40000027 86615
40000027 86612

What I need to accomplish it. PUt one into PCPTCode, the rest I will Concatenate the other CPTCode and put into OtherPCPCode column.

In the vb, I need to loop through the record. I do not how to accomplish this in SQL. Thx.

PNO, PCPTCode, OtherPCPCode
40000028 80061 8373584100841008443684443447984480850258661786618
40000027 86615 8661786617

I have more than 15,000 records in the table which need to fill out the data.

 

[r937]

you cannot do this easily in SQL

which database are you using? there are different techniques for each one

for example, in MySQL, it's trivial, but in other databases it's like a root canal

r937.com | rudy.ca

 

[yan19454]

sql 2000.

 

[r937]

Concatenating a one-to-many relationship into a single column faq183-2146

r937.com | rudy.ca