Completed

Write SQL query

This project was successfully completed by blackjk for $10 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
43
Project Description

Need SQL query written.

Using MSSQL 2010

Table [url removed, login to view]
Table [url removed, login to view], [url removed, login to view], [url removed, login to view] = 315

I need a query which does the following
I have the same item listed in the InventorySuppliers table under LocalSKU and LocalSKU + 'U1"
example
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..

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online