spGetEmailRecipients

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

set nocount on

    SELECT     
        [ID], 
        [EmailID],
        [UserID],
        [AddressBookID],
        [DisplayName],
        [EmailAddress],
        [BackOfficeSystemPeopleID],
        [DataSourceID]
    FROM Email_REcipient 
    WHERE EmailID = @EmailID 
END