I gang

Develop SQL Query

Write up an SQL Query to do the following:

There's 2 databases: a source and destination.  The destination DB has a a table called ArticleWidths & ArticleSizes, where it stores all the sizes and widths of an article.

The source DB has another table called Item_Location, that contains the inventory for all articles.

The stored proc's job is to go through each record in the ArticleWidths table and check if there's stock available on the ItemLocation. If no stock, then we shall remove the corresponding record on ArticleWidth & ArticleSizes. The converse is also true, i.e. if there's stock available on ItemLocation for a specific size/width, you will insert the record on both ArticleSize and ArticleWidth.

The ItemLocation table has an ItemID, 10-digit varchar which matches the ArticleWidth ItemID.

ItemLocation has ItemID, StoreID, StockOnHand, LayawayQty

There's a 1:1 relationship between ItemLocation & ArticleWidths, but NOT necessarily all records in ItemLocation exists in ArticleWidths and vice-verse

Færdigheder: SQL

Se mere: n query, job matches, develop databases, sql query, query table, proc, db query, converse, sql table remove, sql stock inventory, stock inventory sql, insert sql, specific stores, source destination, sql inventory, write article stock, sql stored, stored proc sql, write stock articles, query inventory, check sql, stock sql, inventory sql, source inventory, inventory source

Om arbejdsgiveren:
( 111 bedømmelser ) Boston, United States

Projekt-ID: #935261

Tildelt til:

djain01

As discussed. Thanks

$56 USD in 2 dage
(15 bedømmelser)
4.6