Create Temporary Table

IF OBJECT_ID(‘tempdb..#tmpSearchResults’) IS NOT NULL
DROP TABLE #tmpSearchResults

    CREATE TABLE #tmpSearchResults 
    (
        ID BIGINT,
        ResultType VARCHAR(50),
        ResultTypeID SMALLINT,
        Info1 VARCHAR(100),
        Info2 VARCHAR(100),
        Info3 VARCHAR(100),
        Info4 VARCHAR(100),
        MatchPercentage SMALLINT,
        [Priority] SMALLINT
    );