Write SQL query

Closed

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..

Skills: SQL

See more: top query, write query, Sql query, sku inventory, query table, sql query loop, query loop, inventory mssql, query mssql, loop table, sql inventory, query query, write tree structure query sql, inventory item query, query inventory, write sql 2010, inventory sql, write query sql number orders shipped, need sql query, write sql , mssql example, sql query sql query, top sql, inventory table sql, display salary decimal oracle sql write query

Project ID: #5417585

Awarded to:

blackjk

Hello, pghguest. As I understand, you need this query? select top 1000 not_u1.LocalSKU as not_u1_LocalSKU, u1.LocalSKU as u1_LocalSKU, not_u1.BoydQuantityAvailable as not_u1_BoydQuantityAvailable, u1.BoydQuantityAvail More

$10 USD in 1 day
(5 Reviews)
3.3

42 freelancers are bidding on average $22 for this job

oleg21

Hi there! I have 12+ years of experience with MS SQL Server and this is a piece of cake for me. I can do it in 1 hour, but I mentioned "3 days" as it may be a weekend over here at the time of decision making. O More

$25 USD in 3 days
(64 Reviews)
6.8
customizedata

It means we can use sub query to fetch the quantity and update the BoydQuantityAvailable column where U1 based stuff does not exist

$25 USD in 1 day
(50 Reviews)
5.3
feninsoftech

Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have ex More

$35 USD in 1 day
(17 Reviews)
5.2
rinsadsl

Dear customer I can write this query for you on cheap rate. Looking forward to work with you. Thanks Rinsad

$23 USD in 1 day
(24 Reviews)
5.0
elboukharimu

Hi, I'm very interested helping you creating your query, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, t More

$29 USD in 0 days
(16 Reviews)
4.6
kultech

Dear Sir, I can done, i'm expert MS SQL (store procedure, function, cursor in store procedure) and VS C#. Happy working with you. Thank You

$35 USD in 1 day
(4 Reviews)
4.4
angan

I can help you. .

$25 USD in 0 days
(19 Reviews)
4.4
schungur

SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder...SQL Level3 Holder. More

$25 USD in 1 day
(4 Reviews)
4.1
NourElDeen

Dear Sir, i'm expert on t-sql,Please send give me access to your pc and it will be ready within minutes. Kind Regards, NourElDeen

$23 USD in 1 day
(23 Reviews)
3.9
dogradiwakar

A proposal has not yet been provided

$45 USD in 3 days
(1 Review)
3.6
truongnguyen86

Hi there, i'm expert in reports like this, let me help you with this. I think maybe a couple of hours, waiting for your feedback, i can start whenever you're ready, pls share your data and also the table structure

$28 USD in 1 day
(10 Reviews)
3.5
DeoTech

Hello, I have more than 13 years experience in MS SQL MS SQL has 2008, 2008R2 and 2012 editions. No 2010. I can create your query. Regards

$25 USD in 1 day
(5 Reviews)
3.6
PHPsoldier

Dear Sir, mysql expert here. I can do it. lets start. Please take a look at my reviews. Many Thanks...

$25 USD in 1 day
(4 Reviews)
3.3
codetod

Hi I am an SQL expert with 12+ years of programming experience. The below statement is a bit unclear. I need the BoydQuantityAvailable in the U1 to = the BoydQuantityAvailable where the U1 doesnt exist. A More

$15 USD in 3 days
(7 Reviews)
2.8
sumon355

Hello, I am very much interested to do this work as i am experienced a lot writing sql queries. I think i can write an efficient query according to requirement. Looking forward to have a positive response from you. More

$16 USD in 2 days
(10 Reviews)
2.8
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in MS SQL SERVER , i have more than 7 years in IT projects with 5 years working around Microsoft database development , adm More

$10 USD in 0 days
(2 Reviews)
2.3
ilianMad

Hi, I'm experienced MSSQL developer and I think that's not difficult to achieve. I've done similar project already here in FreeLancer.com, so I don't expect any problems at all.

$25 USD in 1 day
(1 Review)
1.6
huyalex

A proposal has not yet been provided

$20 USD in 1 day
(1 Review)
1.1
smb310570

Please give me the two tables Inventory and InventorySupliers with sample data. So that I can make the query and check the result. Thanks

$10 USD in 1 day
(0 Reviews)
0.5
azlinmuhamadali

We are experienced MSSQL developers and promise to deliver this solution in 2 hours after requirement confirmation.

$21 USD in 1 day
(0 Reviews)
0.0