Lynn Pettis - Thursday, May 24, 2018 3:27 PM

GrassHopper - Thursday, May 24, 2018 3:12 PM

error msg:
Incorrect syntax near 'partition'

With CTE
as (
select *, row_number() over (partiton by HdrID , TabName order by HdrID) as RN
from xlshdr_EC
)
select * INTO dbo.xlshdr_EC_deduped from cte
where RN = 1

Look at the code, partition is spelled partiton.