USP_PRINTMEMBERSHIPCARDS_UPDATEOUTPUTTABLECARDNUMBER

Executes the "Print Membership Cards Update Output Table Card Number" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



CREATE procedure dbo.USP_PRINTMEMBERSHIPCARDS_UPDATEOUTPUTTABLECARDNUMBER
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    begin try

        declare @OUTPUTTABLE nvarchar(100)
        select @OUTPUTTABLE = TABLENAME
            from dbo.BUSINESSPROCESSOUTPUT
            where BUSINESSPROCESSSTATUSID = @ID

        declare @SQL nvarchar(max)
        set @SQL = 'update ' + @OUTPUTTABLE + ' set CARDNUMBER = MC.CARDNUMBER 
                        from ' + @OUTPUTTABLE + ' as OUTPUTTABLE 
                        inner join dbo.MEMBERSHIPCARD as MC 
                        on OUTPUTTABLE.MEMBERSHIPCARDID = MC.ID'
        exec (@SQL)

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0;