spLoadRecord_EmailInvalidAccount

    CREATE PROCEDURE [dbo].[spLoadRecord_EmailInvalidAccount] (            
    @PKID int 
        )
        AS
BEGIN
set nocount on
        SELECT ID, EmailAddress, Count, Active, CreateDate, UpdateDate
            FROM [dbo].[EmailInvalidAccount] WHERE [ID] = @PKID

        SELECT eiar.ID, 
        CASE ISNULL(e.ParentEmailID, 0)
            WHEN 0 THEN e.Name
            ELSE (SELECT '[TEST] ' + [Name] FROM Email WHERE ID = e.ParentEmailID)
        END [NAME],
        ejr.StatusReport BounceText, ejr.SentDate, ejr.RecentDSNDate BounceDate
        FROM [dbo].[EmailInvalidAccountRecipient] eiar 
        INNER JOIN [dbo].[EmailJob_Recipient] ejr on eiar.EmailJobRecipientID = ejr.id
        INNER JOIN [dbo].[Email] e on e.id = ejr.EmailID
        WHERE EmailInvalidAccountID = @PKID
END