How to display rows as columns

dsmbwoy · #1 (**permalink**) 09-27-06, 20:16

Hi everyone. I need some help formating the output of my query. My query currently displays multiple charge items per trip in multiple rows. What I want to be able to do is display these rows in columns so that I only have one distinct row containing all the information. Please see below. Thanks in advance for everyones help.

Current results

Trip Charge Rate
-----------------------
123 Shipping 500.00
123 FSC 35.00
456 Shipping 750.00
456 FSC 45.00

I want to be able to display my output in columns

Trip Shipping_Charge FSC
----------------------------------
123 500.00 35.00
456 750 45.00

Pat Phelan · #2 (**permalink**) 09-27-06, 21:39

Normally I'm terribly suspicious of posts like this... This kind of question at this time of year is almost always homework. For some weird reason I can't identify, I'm willing to give you a straight answer.

Code:

SELECT trip
,  Sum(CASE WHEN 'Shipping' = Charge THEN rate END) AS Shipping_Charge
,  Sum(CASE WHEN 'FSC' = Charge THEN rate END) AS FSC
   GROUP BY Trip

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech