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

Nilesh Shah · Answer

you desctibed everything in your question but did not write what error you get? you have attached only the SP without any tables script sp no one can execute the SP and no one can find out what's the error in it. However looking at your script it seems you are getting more than one record in the in following subqueires which gives you error. You have to use top 1 or some condition so that you get only 1 record from subquery: SET @begin_date_time = ( select begin_date_time from shipment_assignment) SET @end_date_time = ( select end_date_time from shipment_assignment where end_date_time NULL )