You have chosen to sponsor your bid up to a maximum amount of .
Need SQL query written.
Using MSSQL 2010
Table 2-InventorySupliers.LocalSKU, InventorySuppliers.BoydQuantityAvailable, InventorySuppliers.SupplierID = 315
I need a query which does the following
I have the same item listed in the InventorySuppliers table under LocalSKU and LocalSKU + 'U1"
SKU = 123456789 and 123456789U1
I need the BoydQuantityAvailable in the U1 to = the BoydQuantityAvailable where the U1 doesnt exist.
Query will run as a "top 1000" because its a large query and just loop..