select isd.annualCaseAmt, s.skuId, isd.ownerId, isd.interactionDetailId, isd.annualWeightAmt, isd.annualDollarAmt from tbl_CRM_InteractionSaleDetails isd inner join tbl_PRD_Skus s on s.skuId = isd.saleSubjectId where isd.saleSubjectType = 'SKU' and s.inactive = '0' and s.crmActive = 'Y' and isd.ownerType = 'BRO' and isd.annualCaseAmt is not null -- and isd.ownerId in (222,2) order by s.skuId, interactionDetailId update tbl_CRM_InteractionSaleDetails set annualWeightAmt = , annualDollarAmt = where interactiondetailId = #listLen( StructKeyList( _conversionRates ))#