Currently I have an SQL query where I am pivoting the values of one table and then joining that data with another table. The query works but the problem is that I had to hardcode the pivoting for each individual row I was trying to pivot. Now I am working on trying to improve the query by using dynamic pivoting in order to avoid having to hardcode each individual pivot. To do that I have come up with the following query: