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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-07-21 : 06:25:25
|
| can v transpose the results executed fom one sp column and rowsfor ex:executed my sp-result:weekday intime outime totalmonday 9 17 8wednesday 10 16 6like thatbut i want result like below:monday tuesday wednesday thursday friday saturdayin out tot in out tot in out tot9 17 8 - - - 10 16 8 like thatis it possible in query? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-07-21 : 09:05:18
|
| Put the results into a #temp table and PIVOT them. |
 |
|
|
|
|
|
transpose