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 |
|
rudba
Constraint Violating Yak Guru
415 Posts |
 Posted - 2009-01-26 : 13:27:58
|
| I have a table like this:ColA ColB ColC ColD ColEA001 A001 BB NULL A002 A001 NULL NULLA003 A003 CC XXXA004 A001 NULL NULLA005 NULL NULL NULLNow i have to update these data in field ColEOutput on field ColE looks like this:ColA......ColEA001......BBA002 .....BBA003 .....XXXA004 .....BBA005 .....NULL |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rudba
Constraint Violating Yak Guru
415 Posts |
Posted - 2009-01-26 : 14:04:19
|
| I have to Update ColE.On ColB has multiple duplicate data.1)We have to find the first ColC's data Group By ColB. And update ColC data into ColE2)If ColB has data but ColC does not have data, we have to update ColE on ColD's data3) If ColB, ColC,ColD does not have data ColE also NULL value.SELECT Min(ID),ColB from tblA GROUP By ColB Having Count(ID)>=1 |
 |
|
|
|
|
|
Update Script