I work on sql server 2014 I need to use inner join instead of left join
and update Haschemical i case of exist by haschemical or No in case of not exist
on statement below
i need to use inner join instead of left join because data is very big on table
ExtractReports.dbo.FinalComplanceDataDelivery may be 20 million so query take too much time to execute
so How to do that Please ?
update r set r.HasChemical=case when cm.partid is not null then 'HasChemical' else 'No' end
from ExtractReports.dbo.FinalComplanceDataDelivery r with(nolock)
left join
Parts.ChemicalMaster cm with(nolock) on cm.partid=r.partid