I can't seem to get anything to work My table (tbl_Promotions) has 3 columns which I'd like to create the pivot from If I create a temp table which has the 52 calendar weeks of the year ...