Hi , 1. Creating three (empty) tables. 2. Creating stored procedures. 3. Creating a test file – a sequence of calls to stored procedures (in particular, calls to add_page, add_link, enter_website will populate the tables). 4. Creating and testing the views. attached the database with 3 tables.
Hi there, I'm looking for a MySQL and PHP expert to improve a stored procedure running on my database. This stored procedure checks two values in a table, and if one value is less than another value, it increases the lesser value every second using a sleep statement until it equals the greater value, then quits. The scripts and functionality do
Hello. I need a program written in any of the two languages. The program has to do the following: 1) First it has to retrieve a Finger Print template from a database (the database is external; ie not on the FPS itself) 2) Asks the user to scan their finger on the FPS (Finger Print Sensor) 3) Once the finger has been scanned it compares it with the template of step 1 and returns a result (eith...
I have already done the online music web application in netbeans using java,jsp,html,css,jsp,sql but i would like to have one trigger and one stores procedure in this project as per my university requirement
I need someone who can help me comparing USA and UK insolvency procedure
Very simple. You know the work. There is a spreadheet with data in 800+ listings. Using the data provided do the task.
I have a standard operating procedure (SOP) for the local alumni chapter of my fraternity. The format of our SOP is really outdated. I'd like to have the format of the SOP updated so that it has a nice cover page and general structure. I'm not asking that for the content to be updated at this time. My team and I will update the content. The document
We are looking to build a platform where users can swap products. Each user has their own account (like ebay / etsy / etc.) and receive credits everytime they upload a product that is swap-available. Whenever they find something they want, they can use credits in order to make a "purchase"
Hi, I need to develop HR polices and procedures for my small business. I need to ensure that I'm in compliance with all employment regulations and laws. I would like to develop an employee handbook which details, benefits, etc. I'm looking for consulting services for someone with expertise in Human Resources management to ensure that my small business is compliance and my small business ...
...should: 1) Execute a stored procedure on an Azure SQL database. The server name, database name, and credentials will be provided once the project is awarded. 2) Update the [url removed, login to view] & [url removed, login to view] values based on the results of the stored procedure prior to returning the response object. 2a) If the stored<...
I need a script to automate the standard operational procedure “complete pending order”, on my wordpress / woocommerce site. The script needs to be executed periodically, every 15 minutes, and I need to be able to initiate it manually as well, when necessary. I also need to be able to schedule it. My hosting provider supports cron jobs. A third party
I am looking for a site as per the description. This is an extension of a business [url removed, login to view] i want to sell the idea of businesses sending prospective clients video. So my clients would record a short film on a device/phone/tablet/ipad etc and send it to their customers. Their customers would receive a link to click on through email and to their mobile through text, they would ...
...a person with SQL Stored Procedure expertise to review and fix a code. The code serves to extract data from a table in the database and email the results attached as an excel or csv file on schedule. The code to extract the data is ready and the smtp is configured and ready. We will need help with the Stored procedure piece and the SQL job to have the
I need a stored procedure to delete all records that are related directly or indirectly to a root table by foreign key relationships. The database has around 110 tables. The script cannot be created automatically because of cycles in the relationships. Therefore, the tables must be analyzed individually. The root table contains the company name
I need a 2D animated video - Explainer/Infographic video for my organization which is into the healthcare segment. We need a video that explains medical procedures such as a kidney transplant. Please let us know your best quote since we have 10 such videos that need to be produced.