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 |
|
kleinmi
Starting Member
9 Posts |
 Posted - 2002-07-31 : 13:00:52
|
| Hello,I have a huge sql query that returns the following outputDATE SEVERITY BACKLOGdate1 1 33date1 2 44date1 3 55date1 4 66I want to change the output to look like thisDate Severity_1 Severity_2 Severity_3 Severity_4date1 33 44 55 66The SQL statment is large and complex, so I was wondering if there is a way I could do a SELECT statement on top of that query to change the look of the outputThanks!michael |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-31 : 14:05:59
|
| There is an article on the site about cross tab queries (think it's one of Robs).You can put the result of the Sp into a temp table and use that.If you want something generic I answered a question somewhere about putting the results of an sp into a temp table without knowing what the format was using openquery. (I wouldn't advise it though).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
New help fast - Changing the resultset