In Progress

SQL Script , comparing SELECTS

I need a MS SQL Script that compares data inside a database, my programmer is on vacation.

A little info how we manage things in the company:

When we send inventory to a store the store manager inputs the data manually because we don't send the Invoice or Inventory Info Electronically. He has to copy the exact info that a Receipt or Document has in the computer, Like product code and the quantity that is been sent.

OK so everything is stored in 2 tables in a main server, all the documents made in the different databases in each store, ( the data is sent 2 times a day by Internet.)

So the tables have the Number of Document and the quantity that was sent or received. It is stored with the # and a "1" if the store is receiving inventory or a "-1" if it is sending.

So the table should look like this if X store sends Y store something with the Document Number 1111


| Inventory_movement |


Doc Store Product Quant Status


1111 X CD-300 5 -1

1111 Y CD-300 5 1

2222 X PA-200 3 1

2222 X ZR-100 3 1

2222 Y PA-200 3 -1

2222 Y ZR-100 3 -1

** 2222 is an example of the data, if the document has more than 1 products.

*** a document can have a lot of products the Document number isn't unique.



A MS SQL Query that compares the data in the table or tables ( You judge if you need the 2 tables) and returns a list of the Documents that aren't correctly inputed.

So this way we know if the store manager is saving all the data correctly, either to keep the products to him self or just a mistake.

The script has to be efficient , the system we use is web-based.

Hope you understand, any extra info you need please email msg me as fast as you can, we need the script before Tuesday.

I'll attach the a document with more detailed information.



Please it has to be done on Monday 6 of January.



Not paying more than $30

Skills: PHP, Script Install, System Admin, Windows Desktop

See more: what is a web script, what is a computer programmer, what computer should a programmer use, status manager, sql inventory system, sql database programmer, sending invoice, sending an invoice, send an invoice, programmer sql, php sql programmer, php and sql programmer, my sql databases, how to send an invoice, how to be a computer programmer, example of inventory database, everything $5 store, computer system programmer, computer programmer information, computer programmer info, $5 everything store, what is ms sql, web product manager, t-sql with, t-sql in

About the Employer:
( 0 reviews ) Guatemala City, Guatemala

Project ID: #210779

1 freelancer is bidding on average $30 for this job


Hello,Please refer your [url removed, login to view] you.

$30 USD in 1 day
(64 Reviews)