spLoadRecord_EmailJob_Recipient

              CREATE     PROCEDURE [dbo].[spLoadRecord_EmailJob_Recipient]
            ( @PKID int ) AS
            BEGIN

            set nocount on

            SELECT [ID],[EmailID],[EmailJobID],[UserID],[EmailAddress],[MessageDate],
                [SentDate],[UpdateDate],[Sent],[Opened],[OpenedDate],[DSNed],[RecentDSNDate],
                [RecentDSNSignatureID],[RecentDSNCategory],[StatusReport],[Completed],[AddressBookID], 
                [BackOfficeSystemPeopleID],[EmailRecipientID], [MERGEID]
                FROM EmailJob_Recipient with (nolock) WHERE ID = @PKID

            END