kkoehle@valuedrugco.com 4/21/2020 1:57:37 PM

SQL coding

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.

 

 

Version: All
Section: SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3