Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
plsqldev
Starting Member
11 Posts |
 Posted - 2011-07-20 : 15:53:57
|
| My query in the stored procedure retuns some thisng like this.Num Code_1 Code_21 1230 A121 1230 C131 1230 B142 1230 R1153 1234 A123 1234 A134 1124 NULL I need to conacatenete code_2 data by Num as below. Num Code_1 Code_21 1230 A12,A13,B142 1230 R1153 1234 A12,C134 1124 NULLCan any one help me. It is urgent. Thank you in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
plsqldev
Starting Member
11 Posts |
Posted - 2011-07-20 : 22:29:02
|
| I am using SQL Server 2005. My query in the stored procedure retuns some thing like this.Num Code_1 Code_21 1230 A121 1230 C131 1230 B142 1230 R1153 1234 A123 1234 A134 1124 NULLI need to conacatenete code_2 data by Num as below. Num Code_1 Code_21 1230 A12,C13,B142 1230 R1153 1234 A12,A134 1124 NULLCan any one help me. It is urgent. Thank you in advance. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Append the column data
refer to this link below on how to get the output that you want