select * from tbl_IMPORT_RecommendedTargetVolumes with (nolock) where eai_batchid = and ownerType = and ownerId = update tbl_IMPORT_RecommendedTargetVolumes set fseCatalogType = 'SKU', fseCatalogId = where eai_importId = update tbl_IMPORT_RecommendedTargetVolumes set fseCatalogType = 'PRD', fseCatalogId = where eai_importId = select distinct ps.clientsegIdcs.clientsegId from tbl_OPR_ClientSegments ps with (nolock) inner join tbl_OPR_ClientSegments cs with (nolock) on cs.parentClientSegId = ps.clientSegId where ps.ownerId = and ps.fsl_tablecode = and ps.description = and cs.description = update tbl_IMPORT_RecommendedTargetVolumes set fseSegmentId = where eai_importId = select * from tbl_PRD_RecommendedTargetVolumes with (nolock) where ownerType = and ownerId = and catalogType = and catalogId = and linkType = 'SEG' and linkId = insert into tbl_PRD_RecommendedTargetVolumes ( ownerType, ownerId, catalogType, catalogId, linkType, linkId, targetVolume ) values ( , , , , 'SEG', , ) update tbl_PRD_RecommendedTargetVolumes set targetVolume = where ownerType = and ownerId = and catalogType = and catalogId = and linkType = 'SEG' and linkId =