CREATE PROCEDURE FIX$BINARY_Int_JOIN_test
                 @str    varbinary(MAX),
                 @tookms int OUTPUT AS

DECLARE @start datetime
SELECT @start = getdate()

INSERT Int_JOIN(word)
SELECT u.word
FROM   usrdictwords u
JOIN   fixbinary_single(@str) AS a ON u.wordno = a.n

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

SELECT word FROM Int_JOIN
TRUNCATE TABLE Int_JOIN
go


CREATE PROCEDURE FIX$BINARY_Int_UNPACK_test
                 @str    varbinary(MAX),
                 @tookms int OUTPUT AS


DECLARE @start datetime
SELECT @start = getdate()

INSERT Int_UNPACK(number)
SELECT wordno = a.n
FROM   fixbinary_single(@str) AS a

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

SELECT number FROM Int_UNPACK
TRUNCATE TABLE Int_UNPACK
go