Modify an existing program to solve the following issue.
Program recieves data from a scale weighing cans passing on a conveyor, using MS Winsock control, and logs the data to a Microsoft SQL 2000 database, using ADO.
The weight and time of each can is logged to the database, but there is so much data now that the queries used to create reports are timing out. We need to somehow segregate the data, perhapse by making a new table for each lot number.
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.
MS Windows 2000 server and XP