select claimId from tbl_TPM_Claims with (nolock) where readyToAudit = 'Y' and autoPrepared = 'Y' and claimStatus = 'OPEN' and deductionRef is not null order by claimId select claimId from tbl_TPM_Claims with (nolock) where readyToAudit = 'Y' and autoPrepared = 'Y' and claimStatus = 'OPEN' and deductionRef is not null order by claimId