Home Forums SQL Server 2014 Development - SQL Server 2014 how to write Pivot Query for Following RE: how to write Pivot Query for Following
Richard Warr
SSCertifiable
Points: 6963
More actions
November 7, 2013 at 2:56 am
#1664686
First thing to do is be consistent with what you are calling your weeks. They start odd as "Week 44" and "Week 45" but you're pivoting on "Week44" and "Week45".