Update rows which match another table using Stored Procedure in SQL Server

hi andrea thanks for ur attention, i think i will use storeprocedure, cause i want to run it with sql  jobs / scheduler..

may u help

ALTER PROCEDURE [dbo].[sp_shipment_assignment]

AS
BEGIN
SET NOCOUNT ON; 
DECLARE @id int
DECLARE @end_date_time datetime
DECLARE @vehicle_id int
DECLARE @begin_date_time datetime
UPDATE shipment_assignment SET end_date_time = @end_date_time 
(SELECT date_time from event_with_location where vehicle_id = @vehicle_id and date_time >= @begin_date_time)
WHILE EXIST (select @end_date_time from event_with_location)
BEGIN
Update shipment_assignment set end_date_time=@end_date_time , active = 0, 
END

here my sample .but its still getting wrong

Hi Ruben12345,

Will you please explain in more detail? With and Example.

hi indresh..

beyond sample table that i gave.

explain matching from table shipment_assignment

where begin_date_time , origin_id and destination_id will search and matching date_time  on table event_with_location where event_type 31 to end_date_time with event_type 30 AS end_date_time for fill end_date_time to table shipment_assignment

if look on table shipment_assignment for :

begin_date_time = 2017-06-17 00:00:00 

origin_id = 105945

destination_id = 103024

so date_time on table event_with_location macth with begin_date_time , event_type and geofence_name where geofence_name is 'pool cikarang' match with origin_id = 105945

then match event_type = 30 with geofence_name 'FACTORY UNILEVER match with destination_id = 103024 then date_time on this field will update to end_date_time on table shipment_assignment

and i think all the combination should having by vehicle_id

Thanks...

I think this is My Detail..