select r.ownerId, r.ownerType, r.promoNbr, r.requestId, r.contractId from tbl_TPM_Contracts ct with (nolock) left outer join tbl_TPM_Requests r with (nolock) on r.ownerId = ct.ownerId and r.ownerType = ct.ownerType and r.contractId = ct.contractId where ct.ownerId = and ct.ownerType = --and r.promoNbr = '1094001.ZA.001' and r.promoNbr in ( --SELECT AGREEMENT + '.' + REPLICATE(0, 3-len(version )) + cast(version as varchar(20)) SELECT promoNbr FROM z_SCRUM_47309 ) delete from #_table# where ownerId = and ownerType = and requestid = delete from #_table# where ownerId = and ownerType = and requestid = delete from #_table# where ownerId = and ownerType = and contractid = delete from tbl_TPM_Contracts where ownerId = and ownerType = and contractid = delete tbl_TPM_Requests where ownerId = and ownerType = and requestid =

Client: #url.oType##url.oId#

Datasource: #url.dsource#

Step: #url.step#

Rows: #qry_getData.recordCount#

Data removed from #_tableList#