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 |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2008-03-31 : 11:47:05
|
| TaskID PID task Milestone8 3 manasi task 2 8 3 manasi task 3 8 3 manasi task 4 Above is the query of the result I want to show this resultset horizontalyfor that I have to use the cursor such that@M1=Where Milestone=1@M2=Where Milestone=2@M3=Where Milestone=3 and putting this into a temp table with its projectid and taskid.Plz guide me that how to achiev this exactlySwati |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-31 : 14:43:14
|
have a look at the PIVOT keyword in BOL.
elsasoft.org |
 |
|
|
|
|
|
Horizontal output of vertical query with cursors