delete from tbl_BCRM_Planning where ownerId = and ownerType = and planningTimeframe = select fspro_userId from tbl_FSPro_Members with (nolock) where fspro_userId = and ownerId = and FSL_TableCode = select mfr_id from tblManufacturers with (nolock) where mfr_id = select territoryId from tbl_TER_Territories with (nolock) where territoryId = and territoryPath = and ownerId = and FSL_TableCode = insert into tbl_BCRM_Planning( ownerId, ownerType, salesRepId, planningTimeframe, planStartDate, planEndDate, planningTarget, mfr_id, territoryId, territoryPath, targetCount, targetVolume, actualVolume, actualCount ) values ( , , , , , , 'Y', , , , , , , ) No Issues found