I need a batch SQL Script that will run on SQL Server 2000 DB to do the following:
I have attached a prototype with two tables in Access 2000.
Sales Category include, category_number, description, and hiearchy.
Sales Analysis include Sales_ID, Amt, Category, New_Category, date.
I need to reassign categories (in the new_category field) for each record in the sales_analysis table by Sales_Analysis.Store_ID and Sales_Category.Hiearchy.
To do this you must read all records by store, then select the category with the lowest number hiearchy. The category with the lowest number hiearchy should become the new_category for each record in the store.
Note: This is a sample of several million records.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Windows 2000. final script will run on SQL Server 2000