The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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