Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Running out of TempDB when using MERGE Query

    CREATE PROCEDURE [dbo].[RDS_MergeQuery]
        
            @p_SourceDLSDTable varchar(max),
            @p_TargetDLTable varchar(max),
            @p_axAppName varchar(max),
            @p_timestamp varchar(25),
            @rowsAffected INT OUT

        
    AS
            SET NOCOUNT ON;
        DECLARE @SQLString as varchar(max)
        

         -- Performs UPDATES, DELETES, and INSERTS
    SET @SQLString =
        'MERGE dbo.' + @p_TargetDLTable +...

Viewing post 1 (of 2 total)