fnEmailTemplateInUse

            CREATE FUNCTION [dbo].[fnEmailTemplateInUse]
            (    
            @EmailTemplateID int
            )
            RETURNS bit
            AS
            BEGIN
            DECLARE @IsLinked bit
            SET @IsLinked=0
            IF EXISTS (
                SELECT top 1 em.[id]
                FROM [Email] em
                LEFT OUTER JOIN [EmailJob] ej
                ON ej.EmailID = em.ID
                WHERE em.[EmailTemplateID] = @EmailTemplateID
                AND em.[Deleted] = 0
                AND ej.ID IS NULL
                )
                SET @IsLinked=1
            RETURN @IsLinked
            END