hi
I do also get the same error
from below code , could anyone please tell me what I am doing wrong ?
go
;with cte as(
select row_number()over(partition by date order by ID)ID,
Bussiness,Date, Value
from mytable
)
SELECT *
FROM cte
PIVOT (
MAX([Value])
FOR Date IN ( [Nov-18],[Dec-18])
) AS pvt