USP_CUSTOMFORMNOTIFICATION_POPULATEEMAILRECIPIENTS

            CREATE PROCEDURE [dbo].[USP_CUSTOMFORMNOTIFICATION_POPULATEEMAILRECIPIENTS]
            (
            @EmailID int,
            @UserOrRoleID uniqueidentifier
            )
            AS
            BEGIN

                declare @LookupID int
                SELECT @LookupID = [ID] from dbo.ClientUsers where [Guid] = @UserOrRoleID

                if (@LookupID > 0) -- case 1: a single user

                begin
                    INSERT INTO
                    dbo.Email_Recipient
                    (
                        [EmailID],
                        [UserID], 
                        [DisplayName], 
                        [EmailAddress]
                    )     

                    (SELECT 
                    @EmailID as 'EmailID',
                    cu.ID as 'UserID',
                    ISNULL(cu.Firstname,'') + ' ' + ISNULL(cu.MiddleInitial,'') + ' ' + ISNULL(cu.LastName,'') as 'DisplayName',
                    cu.Email as 'EmailAddress'
                    FROM dbo.ClientUsers cu 
                    WHERE cu.ID = @LookupID)
                end 

                else

                begin
                    SELECT @LookupID = [ID] from dbo.ClientRoles where [Guid] = @UserOrRoleID

                    if (@LookupID > 0) -- case 2: a role

                    begin
                        exec [dbo].[spPopulateEmailRecipientsForRole] @EmailID, @LookupID
                    end
                end

            END