CREATE PROCEDURE EXEC$A_Int_JOIN_test
                 @str    nvarchar(MAX),
                 @tookms int OUTPUT AS

DECLARE @start datetime
SELECT @start = getdate()

EXEC('INSERT Int_JOIN(word)
      SELECT u.word
      FROM   usrdictwords u
      WHERE  wordno IN (' + @str + ')')

SELECT @tookms = datediff(ms, @start, getdate());

SELECT word FROM Int_JOIN
TRUNCATE TABLE Int_JOIN
go


CREATE PROCEDURE EXEC$A_Str_JOIN_test
                 @str    nvarchar(MAX),
                 @tookms int OUTPUT AS

DECLARE @start datetime
SELECT @start = getdate()

EXEC('INSERT Str_JOIN(wordno, guid)
      SELECT u.wordno, u.guid
      FROM   usrdictwords u
      WHERE  u.word IN (' + @str + ')')

SELECT @tookms = datediff(ms, @start, getdate());

SELECT wordno FROM Str_JOIN
TRUNCATE TABLE Str_JOIN
go