use T25D001

select SrNo from OPENING_CHALLAN_RECEIVED_FROM_JOB where ChallanDate<='2024-03-31' order by ChallanDate

UPDATE OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL SET READYTOSALE=1 WHERE LOTNO=900086

delete from OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL  where SrNo in (select SrNo from OPENING_CHALLAN_RECEIVED_FROM_JOB where ChallanDate<='2024-03-31')
delete from OPENING_CHALLAN_RECEIVED_FROM_JOB where ChallanDate<='2024-03-31'