use T19S001

CREATE TABLE Tmp_SrNo (TSrNo Varchar(255))
INSERT INTO Tmp_SrNo SELECT SrNo FROM GREY_PURCHASE

DECLARE @RSrNo Varchar(6) DECLARE CUR1 CURSOR FOR SELECT TSrNo FROM Tmp_SrNo OPEN CUR1 FETCH NEXT FROM CUR1 INTO @RSrNo WHILE (@@FETCH_STATUS = 0) BEGIN FETCH NEXT FROM CUR1 INTO @RSrNo
INSERT INTO FIRM_ADDLESS_DETAIL SELECT ''+@RSrNo+'',FormName, SrNo, FldName, FldPerc, FldAddLess, FldPercMulti, FldRound, FldFormula, AccEff, EffAcc, 0 FROM ADDLESS_DETAIL WHERE FormName = 'GREY PURCHASE'
END CLOSE CUR1 DEALLOCATE CUR1

DROP TABLE Tmp_SrNo