Creat two stored procedures in MySQL
$30-250 AUD
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.
Project ID: #7939551
About the project
8 freelancers are bidding on average $125 for this job
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
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
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
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
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
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