select pcr.eai_importId, pcr.check_number, pcr.check_date, round(pcr.check_amount,2) check_amount, pcr.check_number, cr.checkRequestId, cr.claimId, round(c.checkRequestAmount,2) checkRequestAmount, c.checkIssued from tbl_IMPORT_ProcessedCheckRequests pcr with (nolock) left outer join tbl_TPM_CheckRequests cr with (nolock) on cr.ownerId = pcr.ownerId and cr.ownerType = pcr.ownerType and cr.checkRequestId = pcr.check_request_id left outer join tbl_TPM_Claims c with (nolock) on c.ownerId = pcr.ownerId and c.ownerType = pcr.ownerType and c.claimId = cr.claimId where pcr.fse_statusNum = 0 and pcr.ownerId = and pcr.ownerType = and pcr.eai_batchId = update tbl_TPM_Claims set checkIssued = 'Y', checkNbr = , checkDate = , checkAmount = where ownerId = and ownerType = and claimId = and checkIssued = 'N' update tbl_IMPORT_ProcessedCheckRequests set fse_statusNum = , fse_statusDescription = ,fse_claimId = where ownerId = and ownerType = and eai_batchId = and eai_importId =

No records found to process.

Any records shown below were processed before this request.

select eai_batchId "Batch Id", check_request_id "Check Request Id", fse_statusNum "Status", fse_statusDescription "Status Description", fse_claimId "Claim Id", check_number, format(check_date,'MM-dd-yyyy') as check_date, check_amount, payable_code, payable_name, payable_street_1, payable_street_2, payable_city, payable_state, payable_zipcode, payable_attention from tbl_IMPORT_ProcessedCheckRequests where ownerId = and ownerType = and eai_batchId = select * from qmd_importResults where Status < 0 #_ImportHTML# select * from qmd_importResults where Status > 1 #_ImportHTML# select * from qmd_importResults where Status = 1 #_ImportHTML#