HI SQL Experts,
I have a simple SQL query to join 2 tables:
select veh.[YEAR],veh.MAKE,veh.model,veh.TRIMLIST,veh.ICID,vif.[vif #] from [TheVehListBeta2015-04-21] veh
inner join [vifList2015-05-04] vif
on veh.[YEAR]=vif.Yr
and veh.MAKE=vif.make
and veh.MODEL=vif.model
and (TRIMLIST like '%' + vif.Trim + '%' + Convert(nvarchar(10),vif.Drs) + '%' + vif.Body + '%' )
order by [YEAR],MAKE,model
The result of this query is:
4983 records
If I use the same query to update the number is different. Here is 2 different queries to update I have tried:
(1)
update [TheVehListBeta2015-04-21] set EVOXID=vif.[vif #]
from [vifList2015-05-04] vif
Where [TheVehListBeta2015-04-21].YEAR=vif.Yr
and [TheVehListBeta2015-04-21].MAKE=vif.Make
and [TheVehListBeta2015-04-21].MODEL=vif.Model
and TRIMLIST like '%' + vif.Trim + '%' + Convert(nvarchar(10),vif.Drs) + '%' + vif.Body + '%'
(2)
update [TheVehListBeta2015-04-21]
set [TheVehListBeta2015-04-21].EVOXID=vif.[VIF #]
from [TheVehListBeta2015-04-21] veh inner join [vifList2015-05-04] vif
on veh.[YEAR]=vif.Yr
and veh.MAKE=vif.make
and veh.MODEL=vif.model
and (TRIMLIST like '%' + vif.Trim + '%' + Convert(nvarchar(10),vif.Drs) + '%' + vif.Body + '%' )
UPDATE query gives: (
4192 row(s) affected)
Does anyone know where is the difference?
Thank you!