Dynamic SQL Pivot 6. June 2014 sellout SQL (0) This SQL is to demonstrate a dynamic pivot query. It is dynamic because the number of columns is not known in advance. Or because it is known but the number of columns is large but incremental. In this sample the pivot column is week of year. SELECT * INTO #DATA FROM (SELECT CAST('Women... [More]