use T202425 ALTER TABLE RECEIVED_DETAIL ADD CommOn Varchar(15) UPDATE RECEIVED_DETAIL SET CommOn = 'CHEQUE AMOUNT' WHERE GSTPerc=0 UPDATE RECEIVED_DETAIL SET CommOn = 'TAXABLE AMOUNT' WHERE GSTPerc<>0
use T202425 ALTER TABLE RECEIVED_DETAIL ADD CommOn Varchar(15) UPDATE RECEIVED_DETAIL SET CommOn = 'CHEQUE AMOUNT' WHERE GSTPerc=0 UPDATE RECEIVED_DETAIL SET CommOn = 'TAXABLE AMOUNT' WHERE GSTPerc<>0