Creat two stored procedures in MySQL

In Progress Posted Jun 26, 2015 Paid on delivery
In Progress Paid on delivery

Two Simple stored procedures is all that we need -

For an expert it should take less than 2 hours.

Three Tables structures are provided (attached)

Data for two of them are provided

Requirement

1st Stored Proc

Input : Year, Month, DealerCode

Extract Field names from the qrsTablestructure based on label names from qrsDriverTable.

Label names in qrsDriverTable should be restricted to the Input Year and Month

Order the Field names on ID column in Structure Table

Construct a Select statement with the list of field names - to fire against the Orderwrite table - with Dealecode, Year and Month as filter.

Return the Output SQL Select Statement string -

2nd Stored Proc

Input Year & Month

Function : Extract Field names from the qrsTablestructure and Caldate from the qrsDriverTable, based on label names from qrsDriverTable. Label names in qrsDriverTable should be restricted to the Input Year and Month

Return List of Field Names that have CalDate less than current date.

That's IT !

Its a simple and easy project, just posting it since we are short in time and have a few other major pieces being done inhouse.

Happy to come on phone or chat to explain better to get the job done - need this delivered in he next half day.

MySQL

Project ID: #7939551

About the project

8 proposals Remote project Active Jun 26, 2015

8 freelancers are bidding on average $125 for this job

amangpt145

I can complete your project on time and within your budget.I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I will give you our best work with our best s More

$188 AUD in 3 days
(29 Reviews)
5.8
rajawi9999

Hi, I'm an expert in mysql for more than 12 years ago. I'm interested in your project and ready to start straight away...I assure to you that you will be 100% satisfied. Kind Regards Rajawi

$40 AUD in 1 day
(56 Reviews)
5.5
arityinfoway

Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and prov More

$200 AUD in 1 day
(21 Reviews)
5.1
codeblockinfo

We have around 7+ years experience in Java/J2EE development. We have experience in both frontend tech stack (HTML,CSS,ExtJS, Dojo, d3.js, AngularJS,NodeJS,ExpressJS and Javascript) and J2EE tech (Struts, Spring, JSF et More

$111 AUD in 3 days
(2 Reviews)
2.7
maheshtippani

Hi, I have overall 4 years of experience on java/j2ee ,spring, js,css,jquery, groovy,grails,maven,log4j hibernate,Junit,Easymock , mysql,oracle ,wordpress technologies and also work with STS,intellij,netbeans,eclipse More

$55 AUD in 1 day
(3 Reviews)
1.5
BestContentTeam

A proposal has not yet been provided

$30 AUD in 0 days
(2 Reviews)
1.5
emiliatech1

Hello Sir I have understood your requirement of database MySQL queries and willing to do this job for you. It will be done in half day. I am having good command over the concepts of database and queries. I have More

$126 AUD in 1 day
(0 Reviews)
0.0