USP_BATCHTEMPLATE_GETNEXTBATCHNUMBER

Returns the batch number for a batch template.

Parameters

Parameter	Parameter Type	Mode
@BATCHTEMPLATEID	uniqueidentifier	IN
@BATCHNUMBER	nvarchar(100)	INOUT
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BATCHTEMPLATE_GETNEXTBATCHNUMBER
            (
                @BATCHTEMPLATEID uniqueidentifier,
                @BATCHNUMBER nvarchar(100) output,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
            begin
                declare @BATCHNUMBERINGSCHEMEID uniqueidentifier
                select
                    @BATCHNUMBERINGSCHEMEID = BATCHTEMPLATE.BATCHNUMBERINGSCHEMEID
                from
                    dbo.BATCHTEMPLATE
                where
                    BATCHTEMPLATE.ID = @BATCHTEMPLATEID

                exec dbo.USP_BATCHNUMBERINGSCHEME_GETNEXTBATCHNUMBER_ATOMIC @ID = @BATCHNUMBERINGSCHEMEID, 
                    @BATCHTEMPLATEID = @BATCHTEMPLATEID,
                    @BATCHNUMBER = @BATCHNUMBER output,
                    @CHANGEAGENTID = @CHANGEAGENTID
            end