The DISTINCT in the PromoWithWeek CTE is only needed because I am creating random records, which could create duplicate records. You should be able to remove that (though it would not hurt to ...