UFN_BATCH_GETBATCHTEMPLATEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_BATCH_GETBATCHTEMPLATEID
(
    @ID    uniqueidentifier
)
returns uniqueidentifier
with execute as caller
as
begin
    declare @BATCHTEMPLATEID uniqueidentifier;
    select @BATCHTEMPLATEID = BATCHTEMPLATEID from dbo.BATCH where ID = @ID;
    return @BATCHTEMPLATEID;
end