OR on the same thought

turn the date into a USA format date (style 12) YYMMDD

declare @mmddyy char(6)

set @mmddyy = '081709'

select CONVERT(varchar(35),CAST(RIGHT(@mmddyy,2) + LEFT(@mmddyy,4) AS DATETIME),112)

I think this will get close to what you want:

SELECT PartNumber + ',' + Description

FROM table

It should return:

------------------------------------

widget1, Normal Size Widget

widget2, Large Size Widget

widget3, Giant Size Widget

Thanks everyone, I believe this works. It's my first time to post. I will remember to post the test code next time.

It is based on the sum of totalPurchased. The problem is with the date. It can be any 12 month period, so I cannot use where the date...