Hello,

I attempted to modify the stored procedure "AddSearchItemWordPosition" as described a few posts back but i'm having issues. To be clear I am replacing the last INSERT statement:

INSERT INTO dbo.SearchItemWordPosition (
[SearchItemWordID],
[ContentPosition]) 
SELECT ItemWordID, Position FROM @TempList

with the following MERGE statement:

MERGE INTO {databaseOwner}{objectQualifier}SearchItemWordPosition T
USING @TempList S ON (T.SearchItemWordID = S.ItemWordID AND T.ContentPosition = S.Position)
WHEN NOT MATCHED THEN
INSERT (SearchItemWordID, ContentPosition)
VALUES (ItemWordID, Position)

When I try to execute/save the stored proc I get the following error:

Msg 156, Level 15, State 1, Procedure AddSearchItemWordPosition, Line 35
Incorrect syntax near the keyword 'INTO'.

This is strange because that line is much above the INSERT statement that I changed. Anybody else run into this problem? Never done this before so I may have missed something, appreciate any insight!

Thanks,
Josh H.