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 |
KirubaPriya
Starting Member
1 Post |
Posted - 2010-08-06 : 09:35:29
|
Actually how to combine 2 rows or more rows with same member id and different marks?Please Provide me with a clear answerKiruba |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-06 : 11:12:48
|
If you can provide a clear question with example ... No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-08-06 : 12:27:12
|
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-09 : 05:00:55
|
Hintselect memberid,max(case when subject='English' then marks else 0 end) as English,.... from your_tablegroup by memberidMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|