spLoadRecord_EmailJob

CREATE procedure dbo.spLoadRecord_EmailJob
(            
                  @PKID int 
                      )
                      AS
              BEGIN
                  set nocount on
                      SELECT ID, EmailID, Name, OwnerID, GUID, CreateDate, ContentHTML, ContentTEXT, 
                          FromAddress, FromDisplayName, Subject, Priority, ReplyAddress, ReturnReceipt, 
                          ReturnReceiptAddress, ForwardDSN, ForwardDSNAddress, XMLDataSetAddressees, 
                        XMLDataSetMergeData, Status, WSSMTPJobIdentifier, WSDateLastAccessed, NumberRequested, NumberAbsentAddress, NumberOptedOut, 
                          SendAfterDate, EmailTemplateID, [Current], NumberInvalidAccount, ClientIP, ConditionalParentJobID,
              MERGEDATASETSCHEMA,
                            ACKJOBDATAID = (select top 1 ID from EMAILJOBDATA where EMAILJOBID = @PKID order by SEQUENCEID),
                            isnull(NumberInactiveAccount,0) as NumberInactiveAccount,
                            AlternateSubject,               
             MERGESUBJECTSETSCHEMA


                      FROM [dbo].EmailJob 
                      WHERE ID = @PKID
              END