use t27v001

select * into MillSend from (SELECT * FROM GREY_SEND_TO_MILL where srno >='000372') as t1
select * into MillSendTaka from (select * FROM GREY_SEND_TO_MILL_taka_detail where srno >='000372') as t1

delete from GREY_SEND_TO_MILL_taka_detail where srno >='000372'
delete from GREY_SEND_TO_MILL where srno >='000372'

update MillSend set srno = right('000000'+convert(varchar(255),convert(bigint,srno)-300),6)
update MillSendTaka set srno = right('000000'+convert(varchar(255),convert(bigint,srno)-300),6)

insert into GREY_SEND_TO_MILL SELECT * FROM MillSend
insert into GREY_SEND_TO_MILL_TAKA_DETAIL SELECT * FROM MillSendTaka


UPDATE finished_received_from_mill_challan_detail SET MillSendSrNo=right('000000'+convert(varchar(255),convert(bigint,MillSendSrNo)-300),6) where millsendsrno>='000372'