spGetEmailJobRecipients

CREATE PROCEDURE [dbo].[spGetEmailJobRecipients]
    (            
        @EmailID int 
    )
    AS
BEGIN

set nocount on

    SELECT     
        jr.[ID],
        jr.[EmailRecipientID], 
        r.[EmailID],
        r.[UserID],
        r.[AddressBookID],
        r.[DisplayName],
        jr.[EmailAddress],
        jr.[BackOfficeSystemPeopleID],
        r.[DataSourceID],
        jr.[Opened],
        jr.[OpenedDate]
    FROM Email_Recipient r
    LEFT OUTER JOIN EmailJob_Recipient jr on jr.EmailRecipientID = r.ID and jr.[current] = 1 
    WHERE r.EmailID = @EmailID 
END