Hi all,
I have have RMS 1.2 running under SQL 2000. I want to erase all data except the following:
1) Item lookup code 2) Description 3) Available quantity 4) Price 5) Customers 6) Register List 7) Sales Taxes 8) Cashiers 9) Department & Category List 10) Tender Types 11) SuppliersI basically want to start out fresh with the exception of the above list.
Any help on this would be greatly appreciated
here is my archive script which might help. Make sure to get a backup first!
DELETE from RecordDeletedLog where WhenDeleted < '01/01/2010' DELETE from InventoryTransferLog where DateTransferred < '01/01/2010' DELETE from PurchaseOrderEntryDetail where Date < '01/01/2010' DELETE POE FROM PurchaseOrderEntry POE LEFT JOIN PurchaseOrder PO ON POE.PurchaseOrderID=PO.ID AND POE.StoreID=PO.StoreID WHERE PO.DateCreated
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.