One aspect of using the PIVOT is to include a list of columns that will be used as the crosstab of the query. For example, if you wish to display the total quantity ordered by Productid by Year you need to include the list of years for the query. This unfortunately must be a static … Continue reading Dynamic PIVOT by SQL Server Instructor Jeff Jones