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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-08 : 07:41:37
|
| saju writes "Table StructureSlNo PeriodName Subject Day================================== 1 PeriodName1 sub1 12 PeriodName2 sub2 13 PeriodName3 sub3 14 PeriodName4 sub4 15 PeriodName5 sub5 16 PeriodName6 sub6 17 PeriodName7 sub7 28 PeriodName1 sub7 29 PeriodName2 sub6 210 PeriodName3 sub5 211 PeriodName4 sub4 212 PeriodName5 sub3 213 PeriodName6 sub2 214 PeriodName7 sub1 2SO ONHere 1 =Monday 2 =TuesdayHow can I rotate this table based on " Period Name " .plz note that the row may vary in d/f caseplz give help for create any SQL query or spout should be look like thisDay PeriodName1 PeriodName2 PeriodName3 PeriodName4 PeriodName5 PeriodName6 PeriodName7 ----------------------------------------------------------------------------------------1 sub1 sub2 sub3 sub4 sub5 sub6 sub72 sub7 sub6 sub5 sub4 sub3 sub2 sub1 " |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
sql query help 