Fairfield
asked on
Dynamic sql statement to create table
Where whould I put the INTO tbl_UTILIZATION into the following statement?
Declare @strSQL varchar(max)
DECLARE @cols varchar(2000)
-- Assigning Y here just for demo purposes, populate however you want.
Declare @UTILIZED char(1) = 'Y'
SELECT @cols = STUFF(( SELECT DISTINCT
'],[' + cast(Level3 as varchar)
From PPS_SKU_UTILIZATION
ORDER BY 1
FOR XML PATH('')
), 1, 2, '') + ']'
set @strSQL = 'select YEAR, MONTH, ' + @cols +
' from (
select YEAR, MONTH, Level3, UTILIZED
from PPS_SKU_UTILIZATION
WHERE UTILIZED=''' + @UTILIZED + ''') o
pivot (COUNT(UTILIZED) for Level3 in (' + @cols + '))p
ORDER BY MONTH'
exec(@strSQL)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.