Click here to Skip to main content
15,895,667 members
Please Sign up or sign in to vote.
1.60/5 (2 votes)
HI SQL Experts,
I have a simple SQL query to join 2 tables:
SQL
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)
SQL
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)
SQL
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!
Posted

1 solution

Update reflects the number of rows changed, the difference with the select is those rows which have the same value being set hence not changed.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900