Msg 8114, Level 16, State 1, Line 5
Error converting data type nvarchar to int.
Msg 473, Level 16, State 1, Line 5
The incorrect value "DATE_NBR" is supplied in the PIVOT operator.



    select
      *
     FROM (Select METRIC, DATE_NBR as DN, COUNT from
             QC_CM_DATA) p
     pivot
     (avg(COUNT) for DN IN (DATE_NBR)) as pivota