Create Temporary Table

You are here:
← All Topics

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
    );
Next Delete Duplicate Records from the ResultSet
Table of Contents