UPDATE ITEM SET Company='GEN', Category='GEN',  OPStock=0, Stock=0, ROL=0, Cost=0, opCost=0, StandardCost=0, Location='', DamageStock=0, OpDamage=0, PurhRate=0,  ItemNameAR='', RateLock=0,   BOXprice=0, PKTQTY=0, 
                         PKTprice=0, MACHINECode='', ReOrderQty=0, PartNo='', Rate2=0, Rate3=0,  qtyperunit=1, LocCode='', LocName='', QtyChecking='', VATPER=15, StkMode='Inventory', entrydate=GETDATE(), modifydate=GETDATE(), vatrate=(RATE+(RATE*0.15)), CategoryName='', CompanyName='', RetailPer=0, 
                         MinSalePer=0, WholesalePer=0, ModelNo='',Punit=Unit


GO



INSERT INTO ITEMSALESPRICEDETAILS (itemcode, UnitId, qty, rate, Incrate, itemid)
SELECT         itemcode, Unit, qtyperunit, rate,0 AS Incrate,0 AS itemid
FROM            item