DELETE FROM VPOS_MT_REPORT WHERE RPTCODE='RS033' INSERT INTO VPOS_MT_REPORT (RptCode,RptName,RptName1,RptName2,RptName3,RptType,FixVarible,ClassTypeCode,AddClassName,DisableReport,DayEndReport,ctype,RefClass,RefYesNo,ShowEodYesNo,ScriptUpdateYesNo,SortNo) VALUES('RS033','Sales Agent Listing','Sales Agent Listing','Sales Agent Listing','Sales Agent Listing','1','',0,0,0,0,'OOXXXXXXXXXX','XXXXXXXXXX',0,0,1,0) ALTER TABLE dbo.Vpos_eod_GeneralDetails ADD TempField1 varchar(50) NULL, TempField2 varchar(50) NULL, TempField3 varchar(50) NULL, TempField4 varchar(50) NULL, TempField5 varchar(50) NULL GO