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 |
|
elbimbo29
Starting Member
1 Post |
 Posted - 2009-10-08 : 10:23:20
|
| Hi, I am new to SQL and I have a problem. Please helpI have 2 record with identical IdNoIdNo amount1 amount2 status1 status21 100 null cover null1 null 200 null noteSince they have the same IdNo I like this to look likeIdNo amount1 amount2 status1 status21 100 200 cover notehow can I do this. Thanks a lot. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-08 : 10:33:35
|
| Start withselect idno,max(amount1), max(amount2),max(status1),max(status2) from your_tableMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
How to combine 2 records in 1 line?