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 |
infodemers
Posting Yak Master
183 Posts |
Posted - 2013-02-11 : 13:58:15
|
I have the following results from my query.Switch Lead Prefix Fnum Lnum NumberOfOE MDATypeALMA 418-256 LDOR 1 1 9 WKG-NAALMA 418-256 LDOR 2 0 8 WKG-NAALMA 418-256 LDOR 2 1 2 WKG-NAALMA 418-256 LDOR 3 0 8 WKG-NAALMA 418-256 LDOR 3 1 3 WKG-NAALMA 418-256 LDOR 6 0 1 WKG-NAALMA 418-256 LDOR 7 0 2 WKG-NAALMA 418-256 LDOR 7 0 1 WKG-PAALMA 418-256 LDOR 7 1 1 ADVAnd I wish to come to something like this:Switch Lead Prefix Fnum Lnum WKG-NA WKG-PA ADVALMA 418-256 LDOR 1 1 9 0 0ALMA 418-256 LDOR 2 0 8 0 0ALMA 418-256 LDOR 2 1 2 0 0ALMA 418-256 LDOR 3 0 8 0 0ALMA 418-256 LDOR 3 1 3 0 0ALMA 418-256 LDOR 6 0 1 0 0ALMA 418-256 LDOR 7 0 2 1 0ALMA 418-256 LDOR 7 1 0 0 4It is like a pivot on columns NumberOfOE and MDAType...Any Idea?Thanks! |
|
infodemers
Posting Yak Master
183 Posts |
Posted - 2013-02-11 : 15:55:58
|
I got it....I Inserted previous results into a @Results table and then....SELECT * FROM @Results pivot(max([NumberOfOE]) FOR MDAType IN ([WKG-NA],[WKG-PA],[ADV])) As finalRegards! |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|