Creat two stored procedures in MySQL

$30-250 AUD

进行中

已发布

将近 9 年前

$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.

MySQL

项目 ID: 7939551

关于此项目

8提案

远程项目

活跃9 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

8威客以平均价$125 AUD来参与此工作竞价

@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 support.i will complete all tasks which you need ..

$188 AUD 在3天之内

4.9

(29条评论)

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 在1天之内

4.9

(56条评论)

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 provide you our comments & suggestions. ARITY INFOWAY is leading growing company in outsourcing business. We are having 15+ members with expertise in various technology. Web Designing :- HTML5/PSD to HTML/CSS3/JS/Angular JS/Node JS/jQuery/Responsive Web Designing/UI Development/Frontend Development/Logo Designing/Theme Integration/AJAX/Web Services PHP:- MySQL/Core PHP/Magento/Joomla/Wordpress/CMS/Blogs/Codeigniter /Smarty/Moodle/Symfony/Yii/Drupal/eCommerce/OSCommerce/Shopping Cart .NET:- ASP.NET/VB.NET/C#/MVC/ Umbraco/Entity Framework/BioSecure Software/SQL Server/HSQL DB/Kendo UI/Telerik Control/Azure Storage/CDN Storage/WCF/WPF/Web API/HRM Integration/Desktop Applications Mobile Applications:- Android/iOS/Windows JAVA:- J2EE/JSP Servlet Payment gateway Development & integration:- PayPal/Avangate/Skrill/CCAvenue/WorldPay/Stripe Web Hosting:- (Linux/Windows) Hosting/Advance DNS Solution/Server Installation & setup/Mail Server/Router Configuration/Switching & VLAN/VPN/Cloud Server/Critical Data Recovery/Remote Server Support/Server Security/Web Security/Computer Help We never Place any GENERIC BID so we frequently contact you to meet you expectations. We love to spread SMILES :-)

$200 AUD 在1天之内

4.7

(21条评论)

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 etc), DB like (MySQL, Oracle, MSSQL server,PostgreSQL MongoDB)

$111 AUD 在3天之内

4.6

(2条评论)

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. I am a quick learner. . I am a quick learner. if you give a chance to me i will prove myself.

$55 AUD 在1天之内

4.9

(3条评论)

1.5

@BestContentTeam

A proposal has not yet been provided

$30 AUD 在0天之内

5.0

(2条评论)

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 understood most of the stuffs so please let me know when we can discuss the project in detail. Looking forward to work with you. Thanks & Regards Emilia Tech

$126 AUD 在1天之内