Hi, I have a MSQL stored procedure which populates a table in my database with audit scores. I need to add an extra part to the stored procedure which gets the previose audit score and drop this in to a new coloumn in the table. Your be working via TeamViewer to access the database and write the query. This should not take long no more than
I need this asap. should take an experienced sql guy an hour. I need these sql statements put together so it brings back one dataset from the stored procedure. Its a legacy system so please forgive the backticks in the field names: There are three tables, Apoteek_data, holds all the information about products given out. ZINummer, a master
I need a plugin to import to WP Posts and Comments from data stored in 2 custom related MySql tables. Products (id, title, image url, description, score... ) Comments (id, prodict_id, comment, rating value, pros, cons... ) They are product reviews to be imported as posts. The post has some custom fields such as Score vale. The product image
We are searching for a proficient MySQL Developer that also possesses some knowledge of accounting principles, specifically ageing of invoices and allocation of payments and credits to invoices. You will be required to create procedures in MySQL to allocate client payment records to line items on invoices, allocating to the earliest line items first
Hello, since I am new to SQL and programming, I need help with a little task from db automation. I provide you with an SELECT statement fetching data from 3 tables within one database (40 columns, [url removed, login to view] rows are the results of this query). I need this SELECT Statement to be run every night at 02:00 am automatically. The data need to be dumped into an
Need to design an encrypted SVC using NFC card. Would like to use Samsung android phone as a terminal to read/write data on it
...computer which you can access the database to run / test queries. - Query 1 Section Scores - Query 2 Group Scores - Query 3 Score Summary [pre adjsuted score, repeat issues, alerts, action plan failure and final score] I will be pulling this data into an excel workbook so must be ok with this. I have a working stored procedure which does the above
I would like to create a website that allows users to report on publicly available information from eBay. This information on a per eBay ID will need to be captured and stored once every 24 hours. I would like to then be able to display simple reports for users. I am not concerned what technologies are used to do the project but i have a dedicated
In the attached zip file you will find a mysql table definition, a stored procedure, some sample data, and the Java code which calls the Stored Procedure. For details on opening the zip file, please check documentation here: [url removed, login to view] The requirement for this project
...using [url removed, login to view] webforms and runs heavily on data from SQL database. A disgruntled previous developer deleted all the stored procedures from my server / database. This was backbone behind the search filter functions used in the website. All the previous versions of source codes and database are available in this Google Drive Folder ht...
...Microsoft SQL stored procedure that will run daily and provide how many sql queries were executed per day on each database in the SQL server. This result of the stored procedure should be loaded on a daily basis into a table called mytable. The query should output the following columns in mytable: 1) The text of the query that was run 2) Database Name where
I have an SQ...than 8 hours to finish. It took up to 17 hours once recently after a lack of disk space occurred. There is a stored procedure inside the scheduled job which takes the most of the time. Can anyone help me improve the performance, make the stored procedure run quicker and provide some idea on how to monitor the nightly running Agent jobs?
...I will provide design) I need an Email sent to the user as a "Thank you for submitting" (HTML Email, I will provide design) I need the form submissions to be stored into a Database preferably one on a Wordpress plugin. I will want to see some similar work you have done before. My maximum budget is $110 for this. This form will be put
Utility procedure to copy a table from a local server database to a linked server database. this procedure will - Check for a primary key - if non exists then it will through an error log the error and return doing nothing - Get Record Count from local table - if Table Exists on linked server then will drop
This should be an extremely easy project for someone experienced in postgreSQL stored procedures and functions. I'd like the following put into a stored procedure (or function or whatever is easiest). I want to be able to execute a single item and have everything automatically processed. The following is a set of inserts and selects that