UFN_EVENTEMAILTEMPLATE_GETDEFAULTTEMPLATECOUNT

Returns the number of default templates for event

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN
@CONFIRMATIONTYPECODE tinyint IN

Definition

Copy


create function dbo.UFN_EVENTEMAILTEMPLATE_GETDEFAULTTEMPLATECOUNT(@EVENTID uniqueidentifier, @CONFIRMATIONTYPECODE tinyint)
returns int
as
begin
    return (select count(*) from dbo.EVENTEMAILTEMPLATE where EVENTID = @EVENTID and CONFIRMATIONTYPECODE = @CONFIRMATIONTYPECODE)
end