spFundRaiserPopulateTeamEmailRecipients

        CREATE     PROCEDURE dbo.spFundRaiserPopulateTeamEmailRecipients
        (
        @EmailID int,
        @FundraiserTeamID int
        )
        AS
        BEGIN
            INSERT INTO
            dbo.Email_Recipient
            (
                [EmailID],
                [UserID], 
                [DisplayName], 
                [EmailAddress]
            ) 
            (SELECT    
            @EmailID as 'EmailID',
            users.ID 'UserID', 
            users.Firstname + ' ' + users.Lastname as 'DisplayName', 
            users.Email as 'Email'
            FROM ClientUsers users
            inner join FundRaiserSolicitors solicitor on solicitor.ClientUsersID = users.ID
            WHERE
            solicitor.TeamID = @FundraiserTeamID)
        END