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 |
|
wgpubs
Yak Posting Veteran
67 Posts |
 Posted - 2006-01-09 : 18:37:03
|
| Hi all,I have something like this in my database due to an error on the front-end application using it:RspId ItemId Answer12345 999999 Here is part12345 999999 of12345 999999 my answerBasically what I want to do is merge the data and make it a single record as follows:RspId ItemId Answer12345 999999 Here is part, of, my answerAny ideas on how to do this via TSQL?Thanks - wgpubs |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-09 : 19:46:58
|
| Similar Qs r asked in this forum uncountable number of times.Most of the time the referred link is:http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-10 : 01:15:09
|
| The above link suggests efficient method and make use of FunctionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to merge data from mult. records?