UFN_MICROSITE_ACKNOWLEDGEMENTEMAILTEMPLATE_CANBESENT

CREATE function dbo.UFN_MICROSITE_ACKNOWLEDGEMENTEMAILTEMPLATE_CANBESENT(
    @EMAILTEMPLATEID int
)
returns bit
with execute as caller
as begin
    declare @CANBESENT bit = 0;
    declare @FROMADDRESS nvarchar(255);
    declare @SUBJECT nvarchar(255);
    declare @FROMDISPLAYNAME nvarchar(255);
    declare @CONTENTHTML nvarchar(max);    

    select 
        @CANBESENT = 1,
        @FROMADDRESS = coalesce(FROMADDRESS, ''),
        @SUBJECT = coalesce(SUBJECT, ''),
        @FROMDISPLAYNAME = coalesce(FROMDISPLAYNAME, ''),
        @CONTENTHTML = coalesce(CONTENTHTML, '')        
    from dbo.EmailTemplate
    where EmailTemplate.ID = @EMAILTEMPLATEID;

    if (len(@FROMADDRESS) = 0) or (len(@SUBJECT) = 0) or (len(@FROMDISPLAYNAME) = 0) or (len(@CONTENTHTML) = 0)
        set @CANBESENT = 0;

    return @CANBESENT;
end