176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

SQL Data Query
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Bidding period ended early.

Oct 8, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Oct 06, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

We need to output a list of records meeting set conditions from Excel sheets, preferably using a SQL query. The data is contained in 3 Excel sheets:

* Sheet1 is a list of inventory items, we need to filter out items that match a date range and item category type
* Sheet2 is a list of inventory items in retail stores to be joined to sku numbers in sheet1.
* Sheet3 is a list of inventory items in a warehouse to be joined to sku numbers in sheet1. An inventory iitem may be contained in multiple warehouse locations. Same join of the sku numbers found in sheet1.

Obejctive: Output a list of inventory detail in the warehouse locations (sheet) and inventory detail in stores (sheet2) based on the filtered dates and inventory cateogry in sheet1.

Sign in or Register to see more

Job ID: 34124795
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
I have 12 years of experience in the IT industry. I am a PMP and have experience both as a project manager and business analyst. I have...
8
  |  
 5.0   |  Private   |  15 Jobs   |  1 verified credential(s)
Bid ID: 34171996  |  Submitted: Oct 8, 2012 14:58 ET 
Proposal SEALED

 India  |  
I am Senior Database Administrator. I can work on any databases like oracle,ms sql and mysql etc.. I have Experience in Government...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34158145  |  Submitted: Oct 8, 2012 07:02 ET 
Proposal SEALED

SPEC INDIA      
One or more team members at  are verified.  Learn More
 India  |  
SPEC INDIA, a ISO 9001:2008 certified company specializes in providing IT services and solutions in Java, Microsoft, Phonegap, iOS, Android,...
8
  |  
 4.7   |  Private   |  48 Jobs   |  5 verified credential(s)
Bid ID: 34156260  |  Submitted: Oct 8, 2012 05:50 ET 
Proposal SEALED

 India  |  
A manufacturing professional for last 25 years and Information Technology as my passion. When it comes to passion, I'm not restricted to a coding...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34151310  |  Submitted: Oct 8, 2012 02:00 ET 
Proposal SEALED

 India  |  
hi, this is baba shaik from india, completed mca in 2011,. Recently i worked in sybase to oracle migration project. As a pro*c developer we...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34149937  |  Submitted: Oct 8, 2012 00:54 ET 
Proposal SEALED

 India  |  
I have 8 years of IT experience with a very reputed US based IT Service Company and expertise in Data warehousing and Business Intelligence domain....
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34149738  |  Submitted: Oct 8, 2012 00:44 ET 
Proposal SEALED

 New Zealand  |  
Vision: Over 20 years experience in IT, 15 of them in software development. I would be very happy to show you my skills and I am confident you...
3
  |  
 0.0   |  Private   |  0 Jobs   |  6 verified credential(s)
Bid ID: 34144688  |  Submitted: Oct 7, 2012 17:28 ET 
Proposal SEALED

Bright Mind Design      
One or more team members at  are verified.  Learn More
 United States  |  
We are a diversified, united states based technology company Our departments have deep experience and a proven track record of success. Our IT...
1
  |  
 0.0   |  $197 Earnings   |  0 Jobs
Bid ID: 34139594  |  Submitted: Oct 7, 2012 11:47 ET 
Proposal SEALED

 India  |  
I am Bachelor in comp.science. widely I lead the team in my companies from the beginning. I involved in result oriented reports and take care of...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34136144  |  Submitted: Oct 7, 2012 07:25 ET 
Proposal SEALED

 India  |  
Sql Server 2005/2008/2012,SSIS,SSAS,C#,VBA,Excel,CSV,Data Cleansing,ETL,Web Page scrapping,Data scrape
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34132748  |  Submitted: Oct 7, 2012 02:11 ET 
Proposal SEALED

 Egypt  |  
Feel free to contact me regarding any help about MS Excel. I have a very good overall knowledge of Excel, and can assist on most matters. I worked...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34132568  |  Submitted: Oct 7, 2012 01:55 ET 
Proposal SEALED

 India  |  
Specialist - Web Crawler | ERP | Web Site | BI Architect | Data warehouse I have lots of experience in WEB CRAWLING / WEB SCRAPING / BOT...
1
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 34131351  |  Submitted: Oct 6, 2012 23:55 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »