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 |
|
Kolipaka
Starting Member
7 Posts |
 Posted - 2008-11-05 : 06:05:47
|
| Hi Guys, I need your help to write the query for the following situation. The query should be SQL query. There is no front end concept involved here.There is a table say ABC having following entries. You can think that Col1 contains standard, Col2 contains Name, Col3 and Col4 contains the grade. Following is just an example and the number of rows in actual scenario is more.Col1 Col2 Col3 Col4 5th RAM A1 C1 5th RAM B1 D1 6th HARI M1 N1 6th HARI P1 Q1 6th HARI R1 S1 Col1 Col2 Col3 Col4 5th RAM A1,B1 C1,D1 6th HARI M1,P1,R1 N1,Q1,S1Thanks in advans,Kolipaka. |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-05 : 06:09:21
|
| this should be helpful.http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-05 : 07:15:02
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Need to write query