I have a table with contents as follows:
Class, Description, Schedule Number, Markup percent
Example rows:
A, Advertising, 1, 0.00
R, Candy, 1, 0.00
A, Advertising, 25, 0.00
R, Candy, 25, 0.50
A, Advertising, 30, 0.00
R, Candy, 30, 5.50
I want to produce a report that will look like this:
Class Description Schedule 1 Markup Schedule 25 Markup Schedule 30 Markup, etc.
A Advertising 0.00 0.00 5.50
R Candy 0.00 0.50 5.50
So I need to group the data in a different direction, so to speak.
I think I will need to do some Grouping/ Select Distinct Sql here... ?
Thank you.