How to use inner join instead of left join on query below in case of data not exist on chemical master?

[ahmedbarbary]

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

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

[yosiasz]

please go back to other questions you have asked and indicate whether the answers provided to you resolve the issues you were facing.

How to make data pivot dynamically to materialper and suplierperc both?

Need to use 2 pivots DECLARE @ColsList varchar(max), @ColsCols varchar(max), @MetList varchar(max), @SupList varchar(max) DECLARE @Cols TABLE (Head VARCHAR(MAX)) INSERT @Cols (Head) SELECT DISTINCT MetarialID FROM #TempMaterial SELECT @ColsCols = COALESCE(@ColsCols + ',[', '[') + Head + 'Met]' + COALESCE(',[', '[') + Head + 'Sup]' , @ColsList = COALESCE(@ColsList + ',cast(max([', ',Cast(max([') + Head + 'Met]) as numeric(12,2)) as [' + Head + 'Met]' + ',Cast(max([' + …

How to solve error Conversion failed when converting the nvarchar value '24VAC/D

I work on SQL server 2014 I get error when run statement below error say Conversion failed when converting the nvarchar value '24VAC/DC' to data type int. I got error when execut dynamic sql EXEC (@SQL) so how to solve this error please data sample IF OBJECT_ID('dbo.TAllfeatures') IS NOT NULL DROP TABLE dbo.TAllfeatures IF OBJECT_ID('dbo.TCondition') IS NOT NULL DROP TABLE dbo.TCondition IF OBJECT_ID('dbo.TPartAttributes') IS NOT NULL DROP TABLE dbo.TPartAttributes IF OBJECT_ID('dbo…

Join by id rather than VARBINARY

what i try is select partc from #partsc where VerificationHash in(select VerificationHash from #VervicationCode); but i don't need this solution and i need to generate id for two tables then join by id so How to do that please ?

to name a few