SQL Note: change the value of v_barcode in t_outbymachinedetail from the date when isdeleted is 0 to min to isdeleted 0.

 

-- Change the value of v_barcode in t_outbymachinedetail that is the same as that of min when isdeleted is 0 to isdeleted 0.
-- Powered by: Remember to forget
Update t_outbymachinedetail
Set isdeleted = 1
Where PID in (
Select PID from t_outbymachinedetail T1 right join
(
Select min (d_date) as d_mindate, v_barcode as barcode from t_outbymachinedetail where v_barcode in
(Select v_barcode from t_outbymachinedetail
Where isdeleted = 0
Group by v_barcode
Having count (*)> 1)
Group by v_barcode
) T2
On t1.d _ date = t2.d _ mindate and t1.v _ barcode = t2.barcode

Where t1.v _ barcode = t2.barcode
And t1.ischecked = 0

)