Se necesita un store procedure o consulta en MySQL que de una sentencia SELECT (con 3 parametros dos de ellos de fecha, la consulta ya se tiene ) se necesita que para cada fila se reste una columna a los datos de otra tabla y se actualize esa tabla, existen 3 condiciones para realizar las operaciones . En resumen es restar deserciones de alumnos a
Necesito un Procedure para Mysql que es lanzado por un tigger, al ingresar un registro, copie datos de un campo, que tiene cadena de texto separado de comas, una parte de esa cadena, tiene la cantidad de registros columnas de la nueva consulta que anexa datos en otra tabla, el análisis de la cadena dependerá de ciertos criterios que ya estan establecidos
Atencion telefonica de soporte / Capacitacion a clientes / Conexion remota (TeamViewer)<br />Instalacion de: Acrobat reader / Foxit - Configuracion de : Miniprinters ...- Configuracion de : Miniprinters / Puertos<br />Desarrollo y mejora de aplicaciones WEB con PHP, HTML5, CSS<br />Configuracion y mejora continua de triggers, stored procedure en MySQL
...en UML, BPMN, MVC, WEB SERVICES, SOCKET, VISUAL BASIC .NET, ASP.NET, IIS, BOOTSTRAP, JQUERY, BACK END Y FRONT END.-Conocimientos en bases de datos MYSQL, SQL LITE, SQL SERVER, TRIGGER y STORE PROCEDURE. -Experiencia de 2 años o más como desarrollador de software. Ideal haber trabajo en proyectos ERP y CRM.-...
Estamos buscando un freelancer con un muy buen nivel y experiencia en PHP, MySql, Microsoft SQL Server, Apache, IIS /.x y conocimientos del software open source Process Maker. El trabajo será en tres etapas a saber: 1) Necesitamos modificar el software open source Process Maker para que pueda tener single sign on cuando sea llamado desde un
We're working on a project on Visual Basic and need to consume a WebService, we have no experience at all on that, and need help to create a small procedure to integrate into our main project.
Environment: PHP with PHPDesktop and SQLite I am looking for a solution where I can install my PHP based app on client's PC and ensure that no one else can copy and install it on other PC. For this, we can pick up the motherboard ID, merge it with some key from a remote database server, generate a new key, encrypt it and save it in registry or database. You need to make sure that this system...
...demonstratable experience with sql server stored procedures, 3) Including experienced with JSON functions available with SQL Server 2016 The requirement is to finalise a stored procedure currently in draft form that: • Is called when an external system’s API requires a JSON object • Calls on data stored in various tables in the database to create the required
I am learning tensor flow and am trying to see if I can do simple works. I need to create a procedure that rotates a ball from the link I can provide on discussion. As you will see, all I have to do is rotate the animal to be standing up...but alas I haven't been successful. Can you help? **Please request link on reply.
We need help to move some sql codeparts in ColdFusion WebSite (3-4 cfm files) to SQL Stored Procedure. The CF Pages have a combined CF / SQL code that gets some data from sql tables. We need to split the database code from CF and move it to sql procedure. Needs: One ColdFusion developer with good MS Sql Developer knowledge. Cheers Lars
...reader and the One Touch free SDK. Now I have the purchased version and I need to perform the following tasks: -Update the forms using the new version of the SDK -create a procedure for migration of the fingerprint database to the format of the new SDK -Optimize the reading time of the tracks. Additional Information -The SDK was purchased, because the
...2nd grid put 2 buttons with "accept" or "refuse" the order d) invoke a store procedure that process the order Note: the module will be in spanish, but you can work it in english and I will translate it the db will be Oracle, but I will recreate tables in MySQL to work the project and after change it to the final DB This is the first part
...testing something but does not work. As the button will have the NAME of the corresponding nuber, an action should be according to its name. What I pretend to do is to call a procedure based on the button's name. I also need that the form takes the dimensions of the computer screen when it opens. I am sending with this message the [iniciar sesión para ver URL] and roomtest
I need a simple Procedure (not function) in Postgres 11 that can commit and also return a refcursor. Here is an example of the Procedure script: CREATE OR REPLACE PROCEDURE NewProc(pid text,pname text,INOUT cresults refcursor) LANGUAGE plpgsql AS $procedure$ BEGIN cresults:= 'cur'; begin update "testProcedure" set id=pid , name=pname where id...
I will provide a basic source code that I want to improve taking it interface to form/graphs. The program just opens 1 DBF file (main) and from a 2nd dbf file updates some in the first. I need to add some functionallity as well, but simple one, like preview/sort/select/unselect from the changes that are going to be made, and others to discuss. DO NOT APPLY IF YOU ARE NOT AN EXPERIENCED PROGRAM...
...the one of the just received WEB form --> take its default_currency_id 2. use this currency in the new price that is going to be saved in the table 3. keep the existing procedure transferring the previous last price of this offer in the office_price_multi table enduring that in here the currency ID is the one of the previous last price entry and NOT
...application to read from a MySQL server, mark the lines that is read in the MySQL server. Update another SQL Server with the information received from the MySql server. 1. Read the lines that is not read before from the SQL server. (Read InvoiceNumber and Score) - Thinking of calling a Stored procedure on the MySql server, that give the lines
I currently have a couple of Microsoft SQL procedures that was written for me and although it works it takes an extremely long time to run 1+ hour. It is a repetitive script that does a lot of checking through though a long table 12M records. I believe I have optimized indexes but think the task could perhaps be optimized by breaking the search down into 'chunks' (Bottle neck is single p...
Create an executable in .Net 4.5 that will execute an MSSQL stored procedure, save the results to CSV, and upload to a designated SFTP site and directory. exec [usp_GetMicrosByFamilyIdAllLocationsAllRevCenters] '2018-06-18' Where '2018-06-18' is yesterday's date. The credentials and site will be configurable. All source code must be provided.
I need help in Creating a stored procedure in MySQL with conditions. Please read the attached
I need some help with writing a patent.
...server A which hosts files WWW - apache 2. server B which hosts DB - Mariadb 4. Test server C which has WEB+DB -------------------------------------------------------------- PROCEDURE 1. Script will be triggered from php script made by us input variables : - digitalocean api with credentials - digitalocean subdomain name - Server A hostname and port -
I have a oracle package. The package contains a number of stored procedures. The job is to convert the oracle stored procedures to MySQL stored procedures.
I have a fictitious medical murder procedure describing an encephalectomy for illegal organ harvesting and need it translated from English to Russian. Machine translation will not be accepted, and I speak sufficient Russian to look for evidence of this. As mentioned, this procedure is fictitious and is to be used as a clue in a murder mystery game I'm
Hi dears I Need a MYSQL Database Expert to debug a trigger and stored procedure. History: I have one table called slc. This is an OLTP table. Data keeps on getting inserted into this table every couple of minutes. It is a data for streetlighting. Street lights send 2 types of data viz 1) switching data: this is a data they send when they are on/off
We have an existing VMWare (5.1.0) virtual Ubuntu server (10.04 LTS) which needs to be replaced by a newer version (18.04 LTS). The server has 10 websites using mysql (LAMP installation) and using a variety of CMS. Each website, which is managed by different companies, should have their own FTP & ssh user and can only access their specific directories
...creating an alternate reality game to simulate busting an international human trafficking ring, a portion of which involves investigating medical murder. Students will review a procedure for harvesting human amygdalae and other brain tissue for bio medical research with the goal of producing enhanced cognitive speed. Using medical diagrams, I have cobbled
Need help modifying a CSV to export its data in CSV format.
Create Store Procedure Visual C# .NET from Windows Server to Modify data in Mysql Database runing in Linux Server. Simple Test select and update data in mysql. pass parameters by console.
Create Store Procedure Visual C# .NET from Windows Server to Modify data in Mysql Database runing in Linux Server. Simple Test select and update data in mysql.
...MS SQL to MySQL. The DB is simple. I have the create script and the data and the SQL we are looking to convert. Now here is the complication. MySQL does not support the same functions as MS SQL and there for we are struggling to convert the SQL statement like for like. I have been told that to achieve the same result a stored procedure could be
We need a full-stack developer with excelent skills in MySQL (store procedures), CakePHP2 and Bootstrap 3.3.7. The project is a new Order Management Área that must contain the funcionalities listed bellow: - New Order - provide all details of the Buyer and the Destination - Order Panel - like a shopping cart where the buyer chose the products, quantity
I am looking for someone with a legal background and experienced in US tax filing. More precisely, I am seeking advice for the Domestic Streamlined Procedure (form 14654).
We have an existing VMWare virtual Ubuntu server (10.04 LTS) which needs to be replaced by a newer version (18.04 LTS). The server has 10 websites using mysql (LAMP installation) and using a variety of CMS. Each website, which is managed by different companies, should have their own FTP user and can only access their specific directories. You
Hi, We are a sm...operating and we need to write the security audit protocole of our simple infrastructure. I need help from a freelancer with experience in writing IT procedure and with good knowledge of IT infrastructure (MySQL/PHP/GCP/AngularJS/Android). Only candidate with proven prior experience in similar project will be contacted. Thank you
Have a very complex stored procedure that is producing the wrong results, need someone who can correct it to give back accurate counts. Stored proc is 658 lines of code, with multiple temp tables, case statements and inline sql Need finished today . Will give $20 bonus once it's complete.
I need assistance to create a stored procedure for my SSRS project. The stored procedure should handle the following: 1. Count the MAX number of consecutive times a certain rules are met. The rules are as follows: a. Value is > 2 AND b. Value is Not Null AND c. Not Calibrating (Boolean condition) OR d. Value is Null Example: 1.) 1.5
Provide research to incorporate romanian micro LLC Provide detailed requirements address where to go and costs asociated Provide local options for office rentals Provide local options for freelance acounting Provide info about bank account opening for new company If freelancer can make the inscription by himself it will be rewarded and paid in another project.
bid only if already have completed library management ,developed in asp.net c# sql server