Find Jobs
Hire Freelancers

Emergency-Need to solve this SQL Queries- Need to Complete in 12-14 hours from now.

$100 USD

Cancelled
Posted about 9 years ago

$100 USD

Paid on delivery
I’ve attached some documents for your review of tasks that I would expect the candidate to be able to perform with little oversight post two weeks of training/orientation on the legacy system. · [login to view URL] is a very simple select statement used to produce the report2.xlsx. Counting was done on the reporting layer (SSRS). You should be able to understand the SQL that was used as one of the simplest examples of required work. · Health Utilization [login to view URL] is a work activity that maps the input form to the oracle database. o You should be able to understand the JSP that loads the page, the JSP that saves the page, and the .xsl. I’ve included all of the queries that are pulled from the data access layer as tabs in the spreadsheet. Given this information, you should be able to understand any business rules identified here and recreate the “Form Breakdown” tab. § Question: Can you identify where data is checked for correct values? · [login to view URL] is an example of fairly poorly written code. What would your approach to be to refactor this for efficiency? · [login to view URL] is code that was written to generate a report. You should be able to walk through this and be comfortable creating something similar in fashion. This code does contain performance issues as well and like the clicksql, I’m curious to know how you would approach refactoring this?
Project ID: 7379516

About the project

2 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $100 USD for this job
User Avatar
SQL commands ( SQL queries ) is my game, please have a look at my profile to know my aims, Kind regards
$100 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Herndon, United States
5.0
1
Member since Mar 13, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.