SQL Script

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.

1. Sales_Category

2. Sales_Analysis

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.

## Deliverables

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.

## Platform

Windows 2000. final script will run on SQL Server 2000

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: prototype date, on sql, sql script , sql final, php sql 2000, sql run package, sql select select, script run access sql, php script read table, sql select, php run batch script, script prototype, sql table analysis, script sql table, windows form sql server, program records sales, sql select script, prototype sample, read sql server, install sql script, sales analysis access, ready script sales, php form sql, server analysis php script, sql analysis

Acerca do Empregador:
( 68 comentários ) United States

ID do Projeto: #2963684

Concedido a:


See private message.

$7 USD em 1 dia
(111 Comentários)

1 freelancer está oferecendo em média $7 para esse trabalho


See private message.

$17 USD em 1 dia
(552 Comentários)