UFN_BATCH_GETREPORTTABLENAME

Returns control or exception report table name.

Return

Return Type
nvarchar(128)

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN
@EXCEPTIONREPORT	bit	IN

Definition

Copy



CREATE function dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID uniqueidentifier, @EXCEPTIONREPORT bit) returns nvarchar(128)
as 
begin
    declare @TABLENAME nvarchar(128);
    declare @TABLEKEY nvarchar(9);

    if @EXCEPTIONREPORT = 0 
        set @TABLEKEY = 'CONTROL';
    else
        set @TABLEKEY = 'EXCEPTION';                    

    select 
        @TABLENAME = TABLENAME 
    from 
        dbo.BUSINESSPROCESSOUTPUT 
        inner join dbo.BATCHSTATUS on BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = BATCHSTATUS.ID
    where 
        BATCHSTATUS.PARAMETERSETID = @BATCHID AND 
        BUSINESSPROCESSOUTPUT.TABLEKEY = @TABLEKEY;

    return @TABLENAME;
end