I try For update only rows which match another table in sql with stored procedure with join to another table
on field end_date_time will search on table_b based date_time start to compare begin_date_time on table a with event_type 31
so the result of store procedure is
id = 207
vehicle_id = 10884919
shipment_no = A001
origin_id = 105945
destination_id = 103024
begin_date_time = 2017-06-17 00:00:00.000
end_date_time = 2017-06-17 01:31:39.000
active = 0
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.