fnGetEmailTemplateGuidFromId

            CREATE FUNCTION [dbo].[fnGetEmailTemplateGuidFromId]
            ( @EmailId int ) RETURNS uniqueidentifier
            AS
            BEGIN
                DECLARE @Guid AS uniqueidentifier
                SET @Guid = (SELECT TOP 1 [Guid] FROM [dbo].[EmailTemplate] WHERE [ID] = @EmailId)
                RETURN @Guid
            END