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

Evner: SQL

Se mere: n query, job matches, develop databases, develop sql query sql query, write query, 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, query query, SQL stored, stored proc sql, write stock articles, query inventory, check sql, stock sql

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

Projekt ID: #935261

Tildelt til:


As discussed. Thanks

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