I have some low knowledge about Visual Foxpro 6. It has to be with this version. I am creating a reservation system for a small hotel. What I now have is at [login to view URL] I need to change the labels in the form for command buttons and, instead of having to type the room name to use, I want it to be selected as soon the button is
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...
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
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.
...pre-launch, and building a base of content for our launch. As the Content Writer at Aedit, you will help us with topic research and content generation, editing and management. We will provide you with a base of medically-sound content from our network of doctors to start with, as well as required keywords (for SEO purposes) with each assignment to help
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
...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 together a set of mock surgical
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.
...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 used to create the same query outcome. I have attached 3 files 1) the create table script, 2) a data
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).
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
Pr...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
Were looking to hire a partner who can help us create medical illustrations to describe a surgical procedure, similar to those depicted in medical text books.
Require someone who is exceptionally talented at writing and editing technical documents to make them very readable and simple without loosing the guidance value. It's 11 pages including about 4 pictures and tables; approx 4,000 words.
...version 7 for MS SQL driver) to call different types of Stored procedures in MS SQL server (READ: NOT MYSQL !!!!!!) A stored procedure with input and output parameters. Set values for Input and Read the output parameters after calling stored procedure. A stored procedure with input and output parameters and returns a recordset. Set values for the...
I need to convert a stored procedure from SQL Server to My SQL, the stored procedure is used to get dynamic data base on the parameters the stored procedure is attached below
simple work - having a image which needs to be viewed as replacement component like small hardware replacement kind of laptop memory card replacement. need to show in hololens , so user can feel the hardware replacement
...aggregates this data from Amazon APIs for any given Amazon seller who provides us with his Amazon authentication credentials. This Microservice should then import the required data via our API. Within a second consecutive project the service provider (you) could potentially also develop this microservice and its integration for us, depending how the first project
Dear All, We are looking for a specialist who can write a Coffee Shop Operations Policy and Procedure from scratch. So can you kindly write for me a brief on the services which you can provide us from A to Z related to this project. Looking forward to hearing from you, Thanks in advance :),
...have a system that is in production that has a store procedure that actually is called by an ASP.net Solution and instead of calling the database, makes certain HTTP calls etc. We need an expert to edit the procedure so it logs the parameters and the calls that are been made to the store procedure so we know how to call it, from an external application
For guidance , please check the POEA requirement on Flowchart of Recruitment Procedure and 4 year Business Plan .
Need a SQL Stored Procedure / Function that takes Ingredients String and Returns table of Ingredient Descriptions in order. MUST BE FAST! Parameter: "Sugar, Cocoa Butter, Skim Milk, Chocolate, Milkfat, Lactose, Soy Lecithin, Artificial Flavor" Returns: 1 Sugar 2 Cocoa Butter 3 Skim Milk 4 Chocolate 5 Milkfat 6 Lactose 7 Soy
Hi, I need a step by step procedure for hydraulic fracturing process. I need the part of a job during hydraulic pipes, packers and so on are installed and placed inside a well. Pictures and schemes would be highly usefull.
I have XML files and I need to import them into sql database table by creating a procedure.
Hello, I'm looking for who has enough experience about .Net web development and Mssql. Also important skill is optimize stored procedure. Please bid if you can do those jobs, I will interview and if pass, then he can join our team.