您
[Local-User-ID]和之间缺少逗号
[Activity-Type]。
尝试：
INSERT INTO attributeddoubleclickactivities ([Time], [User-ID], [IP], [Advertiser-ID], [Buy-ID], [Ad-ID], [Ad-Jumpto], [Creative-ID], [Creative-Version], [Creative-Size-ID], [Site-ID], [Page-ID], [Country-ID], [State Province], [Areapre], [OS-ID], [Domain-ID], [Keyword], [Local-User-ID], [Activity-Type], [Activity-Sub-Type], [Quantity], [Revenue], [Transaction-ID], [Other-Data], ordinal, [Click-Time], [Event-ID]) SELECt [Time], [User-ID], [IP], [Advertiser-ID], [Buy-ID], [Ad-ID], [Ad-Jumpto], [Creative-ID], [Creative-Version], [Creative-Size-ID], [Site-ID], [Page-ID], [Country-ID], [State Province], [Areapre], [OS-ID], [Domain-ID], [Keyword], [Local-User-ID], [Activity-Type], [Activity-Sub-Type], [Quantity], [Revenue], [Transaction-ID], [Other-Data], REPLACE(ordinal, '?', '') AS ordinal, [Click-Time], [Event-ID] FROM activity_reports WHERe [Time] BETWEEN @dtmFrom AND @dtmTo AND REPLACe(ordinal, '?', '') IN (SELECT REPLACE(ordinal, '?', '') FROM activity_reports WHERe [Time] BETWEEN @dtmFrom AND @dtmTo EXCEPT SELECt ConVERT(VARCHAR, tripid) FROM visualsciencesactivities WHERe [Time] BETWEEN @dtmFrom AND @dtmTo);
