UFN_BUSINESSPROCESS_GETOUTPUTTABLENAME

Returns the output table name of the given business process status.

Return

Return Type
nvarchar(128)

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN
@TABLEKEY	nvarchar(50)	IN

Definition

Copy



            CREATE function dbo.UFN_BUSINESSPROCESS_GETOUTPUTTABLENAME
            (
                @BUSINESSPROCESSSTATUSID uniqueidentifier,
                @TABLEKEY nvarchar(50)
            )
            returns nvarchar(128)
            with execute as caller
            as
            begin
                declare @TABLENAME nvarchar(128);

                select 
                    @TABLENAME = TABLENAME 
                from 
                    dbo.BUSINESSPROCESSOUTPUT 
                where 
                    BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID
                    and TABLEKEY = @TABLEKEY;

                return @TABLENAME;
            end