Update only rows which match another table in sql with SP

Question

i try To Create Storeprocedure for update rows end_date_time on shipment_assignment

the condition is begin_date_time and origin_id will search and match date_time on table

event_with_location with event_type AS start to destination_id on table shipment_assignment will search to geofence_name on event_with_location with type 30

AS end_date_time and set active = 0

 

i have attach my test Storeprocedure test code, but still getting error.

will anyone can help me

thanks 

 

 

so the result will looks like at table result