USE T23S001

Create Table TMP_JOURNAL_VOUCHER (SrNo Varchar(6),CrDrSrNo Numeric(3),JVDate DateTime,DebitCode Varchar(7),CreditCode Varchar(7),Discription Varchar(255),VouNo Varchar(6),Amount Money,Uname Varchar(255))

insert into TMP_JOURNAL_VOUCHER select * from JOURNAL_VOUCHER UNION select * from JOURNAL_VOUCHER 

DELETE JOURNAL_VOUCHER

INSERT INTO JOURNAL_VOUCHER SELECT * FROM TMP_JOURNAL_VOUCHER 

DROP TABLE TMP_JOURNAL_VOUCHER