176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

ProSphere Finding Usage History
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
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Sep 04, 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
  • U.S. freelancers must have W9
Sign in to view client's details

Update attached query to a Stored Procedure. In the query i have made two comments on what needs to be down.

1. Change the case statement logic to show the past 24 months with dynamic column names
9/1/2012, 8/1/2012,.. 9/1/2011, 8/1/2011,,9/1/2012. The calculation has to be in month year buckets as is case stament below

2. In the where Clause change the line "AND ProdTable.FinishedDate > '2010-12-31' " to handle last 24 months.

3. if you see any way to enhance query performance, please do so.
------------------------------------------
Added 5 SEP 2012, 10:21 AM EDT
The job needs to run on SQL Server 2005.
------------------------------------------
Added 5 SEP 2012, 10:21 AM EDT
The job needs to run on SQL Server 2005.

Sign in or Register to see more

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

 United States
Winner
Build new database systems Backup and restore database system Set security on database, table, column... Maintainance :re-index, improve...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33324569  |  Submitted: Sep 6, 2012 13:51 ET 
Delivery
Within 1 day
$25.00

 India  |  
UnIT is a group of IT professionals with vast experience serving different verticals and technology. We have come together to work hand-in-hand...
1
  |  
 0.0   |  $0 Earnings   |  1 Jobs
Bid ID: 33260615  |  Submitted: Sep 4, 2012 13: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 »