uSE T21W001
 
sELECT * fROM FIRM_ADDLESS_DETAIL wHERE FormName='gENERAL pURCHASE' oRDER bY FormSrNo, SrNo

dELETE fROM FIRM_ADDLESS_DETAIL wHERE FormName ='gENERAL pURCHASE' aND SrNo=9 aND FldName='rOUNDING oFF'
dELETE fROM FIRM_ADDLESS_DETAIL wHERE FormName ='gENERAL pURCHASE' aND SrNo=8 aND FldName='tCS'


USE T21H003


SELECT * FROM FIRM_ADDLESS_DETAIL WHERE FormName='SALE BILL'  ORDER BY FormSrNo, SrNo
DELETE FROM  FIRM_ADDLESS_DETAIL WHERE FormName='SALE BILL' AND FldName='ROUNDING OFF' AND SRNO=13 AND FormSrNo >='000019'