Creat two stored procedures in MySQL
$30-250 AUD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #7939551
Σχετικά με την εργασία
8 freelancers κάνουν προσφορές κατά μέσο όρο $125 για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα