How to combine 1 header column and Pivot 2 detail columns using SQL Looking for a dynamic pivot table for Orders that pivot out the details based on ItemId