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 |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2006-03-20 : 23:51:39
|
| There are two fields in a Table Stduent_Ranking namely (question_id, ranking) and the values are stored as below Stud_id Ranking 1 1 1 2 1 3 1 4 2 1 2 2 2 3 2 4 3 1 3 2 3 3 3 4 My Question is how can can I retrieve the info in five dummy columns from SELECT Query Please help me I have to do something with this urgently Stud_id Ranking(1) Ranking(2) Ranking(3) Ranking(4) 1 1 2 3 4 2 1 2 3 4 3 1 2 3 4 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-21 : 00:17:27
|
| Homework question?Show us the query that you have so far so we can see what is wrong.CODO ERGO SUM |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
majkinetor
Yak Posting Veteran
55 Posts |
Posted - 2006-03-21 : 04:33:05
|
| >>Homework question?:)) |
|
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-03-21 : 19:20:00
|
| r u serious? you want us to do your homework? post up your select statement and we'll critque.. if not I'll have to spank you and I do that trousers down... |
|
|
|
|
|
|
Please slove my question in SQL