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 |
|
bharath405
Starting Member
2 Posts |
 Posted - 2012-10-31 : 04:24:06
|
| Hello All,I need an SQL query which combines two rows of a same table into single row without altering number of columnsPlease have a look into the examplecolumns id TEXTID L9 L7 L10 L12 L16L9,L7,L10,L12,L16 1 1Error Störung Error Incident DisturboL9,L7,L10,L12,L16 8 8 Alarm Alarm Alarma Alarme Allarmeexpected output should becolumns id TEXTID L9 L7 L10 L12 L16L9,L7,L10,L12,L16 1 1 Error_Alarm Störung_Alarm Error_Alarma Incident_Alarme Disturbo_AllarmeK BHARATH KUMAR REDDY |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
|
|
Merging two rows of an SQL table into single row
