176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Creation of a SQL correlated subquery
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

Job awarded.

Oct 22, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sun, Oct 21, 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: $30 - $70
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I have two SQL queries that I need to have execute together and return one dataset. This project should be very simple for a SQL expert.

Currently one query returns work completed according to a production schedule on a specific date range. The other returns work completed on a specific date range irrespective of the date that work was scheduled to be completed. The combined query should return all work scheduled and completed for a date range.

The work completed is aggregated by Finished Good type.

Lastly, the database is proprietary SQL92 compliant. BBj Pro5 which means that this can only be completed using basic SQL syntax. more info here   [obscured]  /BASISHelp/WebHelp/index.htm#basismans/p5_vp5_and_bbj_online_manuals.htm

I have an intermediate working knowledge but this is over my head. Ideally we would work together over skype test and debug the query there is no internet access to the database server.

Sign in or Register to see more

Desired Skills
SQL
Job ID: 34543548
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   |  14 Jobs   |  1 verified credential(s)
Bid ID: 34567891  |  Submitted: Oct 22, 2012 12:18 ET 
Proposal SEALED

Ali Safder      
Ali Safder's identity has been verified.  Learn More
 Pakistan  |  
Expert in VB, C#, .NET, and Sql Server with database analysis and design. Skilled in developing business plans, requirements specifications, user...
4
  |  
 4.0   |  Private   |  0 Jobs
Bid ID: 34557493  |  Submitted: Oct 22, 2012 06:05 ET 
Proposal SEALED

I am an MS Certified Technology Specialist (MCTS). With over 10 years of experience as an IT professional, I am an expert SQL, SSRS and .NET...
3
  |  
 0.0   |  Private   |  1 Jobs
Bid ID: 34551765  |  Submitted: Oct 22, 2012 01:52 ET 
Proposal SEALED

 India  |  
I have 3 years of experience in C#.NET, ASP.NET, Javascript, JQuery, Angularjs.js, Ajax, Web Services, Windows Services, MVC framework etc. I have...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34547482  |  Submitted: Oct 21, 2012 21:22 ET 
Proposal SEALED

Ryan B.      
Ryan B.'s identity has been verified.  Learn More
 United States  |  
I have 4+ years of professional experience with Web Technologies. My primary skills reside in DotNetNuke, SQL, JavaScript, PHP, CSS and HTML. I...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34546218  |  Submitted: Oct 21, 2012 19:22 ET 
Proposal SEALED

 Greece  |  
Winner
SQL expert, database and query optimizations
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34545762  |  Submitted: Oct 21, 2012 18:34 ET 
Delivery
Within 1 day
$30.01

 India  |  
With our strong experience in web, mobile and desktop application development for so many years we can complete nearly any development work in less...
9
  |  
 4.9   |  Private   |  108 Jobs
Bid ID: 34544765  |  Submitted: Oct 21, 2012 17:05 ET 
Proposal SEALED

 Ukraine  |  
I am a professional developer with more than 10 years of experience in web technologies and desktop development. I have a long track record of...
6
  |  
 5.0   |  Private   |  37 Jobs
Bid ID: 34544371  |  Submitted: Oct 21, 2012 16:33 ET 
Proposal SEALED

 India  |  
We have 5+ years experience in PHP web designing, Oracle, my SQL, java. Highly recommended and has true expertise in Website design, Wordpress &...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 34544137  |  Submitted: Oct 21, 2012 16:16 ET 
Proposal SEALED

 Pakistan  |  
Experienced PHP, ASP.Net developer, expertise both in desktop and web application. Expert in database driven application with excellent user...
10
  |  
 4.7   |  Private   |  74 Jobs   |  1 verified credential(s)
Bid ID: 34544030  |  Submitted: Oct 21, 2012 16:07 ET 
Proposal SEALED

 Bosnia and Herzegovina
Full CV is available upon request.
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34543978  |  Submitted: Oct 21, 2012 16:04 ET 
Proposal SEALED

 Serbia
I am currently studying electronics at the University on Nish (Serbia), at the department for computer science, sector Software engineering. My...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 34543942  |  Submitted: Oct 21, 2012 16:03 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 »