— TEST DATA
DECLARE @PartDescription TABLE
(
PartNumber Varchar(20),
Name Varchar(20)
)
INSERT INTO @PartDescription values (‘1234-1234’, ‘Sprocket’)
INSERT INTO @PartDescription values (‘1234-5678’, ‘Rail’)
INSERT INTO @PartDescription values (‘1234 2345’, ‘Guide’)
INSERT INTO @PartDescription values (‘1234-3456’, ‘Handle’)
INSERT INTO @PartDescription values (‘1234 4567’, ‘Bolt’)
DECLARE @PartSales TABLE
(
PartNumber Varchar(20),
Year int,
Sales float
)
INSERT INTO @PartSales values(‘1234*1234’, 2014, 100)
INSERT INTO @PartSales values(‘1234*5678’, 2014, 200)
INSERT INTO @PartSales values(‘1234*2345’, 2014, 250)
INSERT INTO @PartSales values(‘1234*3456’, 2014, 150)
INSERT INTO @PartSales values(‘1234*4567’, 2014, 210)
INSERT INTO @PartSales values(‘1234*1234’, 2015, 170)
INSERT INTO @PartSales values(‘1234*5678’, 2015, 290)
INSERT INTO @PartSales values(‘1234*2345’, 2015, 220)
INSERT INTO @PartSales values(‘1234*3456’, 2015, 200)
INSERT INTO @PartSales values(‘1234*4567’, 2015, 170)
INSERT INTO @PartSales values(‘1234*1234’, 2016, 200)
INSERT INTO @PartSales values(‘1234*5678’, 2016, 300)
INSERT INTO @PartSales values(‘1234*2345’, 2016, 350)
INSERT INTO @PartSales values(‘1234*3456’, 2016, 350)
INSERT INTO @PartSales values(‘1234*4567’, 2016, 110)