a guest Jun 16th, 2019 69 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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.
- FROM (Select METRIC, DATE_NBR as DN, COUNT from
- QC_CM_DATA) p
- (avg(COUNT) for DN IN (DATE_NBR)) as pivota
RAW Paste Data