SELECT
*
From
(SELECT
Line_item_Duty as [DUTY],
[Supplier] as [SUPPLIER],
Datepart(MM,Entry_Summary_Date) as [MONTH]
from [ADHOC].[ATS_ESH] H
INNER JOIN ADHOC.ATS_ESL L
ON H.TRANS_SK = L.trans_Sk
WHERE
H.Importer = 'FORD'
AND Entry_Summary_Date > '1/1/2018')
as Data
PIVOT
(
Sum([DUTY])
FOR
[Month]
IN ('01','02')
) AS JEFF
Results in Error: Incorrect syntax near '01'.
Thoughts? thanks so much