Xml sql stored proceedure työt

...agreement 3. Word doc version of the Rental Agreement (we already have this document see attached) All fields must pre-populate and new file needs to be saved 4. The files will be stored on Google drive and accessed by my team so the main functionality of the spreadsheet needs to be protected. 5. Provide on-going advice on best solution for each problem.

For now, we have clear user's passwords (not hashed) stored in our database (more than 12000 users). We want to secure everything by hashing passwords properly.

I have had two smart cards but one of them got lost and I want to make another copy of the card. So, the task is simply copying the information from one smart card to an empty one.

Need help in writing a complex stored procedure

A Stored Procedure is written to map data from one table to another. Attached is the SP in txt file format. List of Variables are provided in excel sheet. Read the SP and see how if each field mapped in the excel sheet is coded correct or not. If coded correctly change the row color to green if not mapped correctly changed the color to Red

Scrappers A simple Python scrapper for 2 websites (one with captcha, other without captcha) Upon a parameter number the python code must extract an “scrapper index” to be a selector of the 2 URLs, it will check on a datastructure indexed by the “scrapper index” that points to an URL and a lambda code to be called (scrapper), it works like a dictiionary, like a DNS. With t...

We got 3 tables: Project, ProjectWork, Employee Project: Project INT PK, Projectname VARCHAR ProjectWork: Project FK, Emp INT FK, Hours INT, SumHours INT Employee: Emp INT, PersonalId INT, Lastname VARCHAR, Firstname VARCHAR. I need somebody with experience with triggers to give me 3 triggers: - If I insert new project into projectwork table ---> increase sumhours by the hour value i ad...

...execute Stored Procedures Microsoft SQL Server 2012 and show the result set in grids in the mobile screen. The Stored Procedures already exists; the developer will not get involved with the business rules. The App will have 3 forms: 1-Login Screen: With fields Company, User and Password and button OK. When clicked button OK should execute Stored Procedure

I have an excel with a lot of rows, and after some logical (running macros), the excel convert and gave some ou...lot of rows, and after some logical (running macros), the excel convert and gave some outputs. I need to migrate that logic to database. I have excel rows in a SQL table, and i need a Stored Procedure to transform the data to other table.

I need you to develop some software for me. I would like this software to be developed using mysql and golang

we are planning migrate mssql database to mysql [kirjaudu nähdäksesi URL:n] require experts to do this project and also need to suggest best architecture for mysql without downtime.

There are stored Procedures in mysql and some golang codes to be worked on. I need an experienced expert on these two stacks

I have a project that requires the use of stored procedure in mysql. With some other Api making golang [kirjaudu nähdäksesi URL:n] freelancer has to be a confident expert to help fix issues in the current code.

I I have a big procedure in vb 6 which merely deals with queries and loops i feel i can convert the whole code in to Sql Stored procedure as it merely updates database with some calculated values as there are a lot of loops in the procedure i find it difficult for myself to convert as it may requires a lot of cursors may be

Only those folks who have real experience with SQL Stored Procedure and R code should contact. I have a code which I want to understand.

I need someone who can develop a small Android app that reads a PDF file from a Url and print it to a Bluetooth printer paired to the smartphone. Other programmer has already done: 1. Create the PDF 2. Store it in a Url (IIS server) using ASP.net What is needed to do is: 1. Create an Android app (compatible from 5.1 +) that is running in “background”. (not sure of the correct name/c...

Hello Freelancer, Help In mysql stored procedure.

pl/sql stored procedures and triggers that will delete and update a table

...lot of 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...

Write programs to extract the data needed for the two document types above (TEAM_SCORES and PLAYER_DATA) from the relational data files, and load these documents into the MongoDB system.

Create a while loop. Get all summary result to a new table.

Hi I am looking for an expert DBA to fix some stored procedures and few optimisations work for our website. We are looking to work with individual freelancer and not a company - so if you are a company, please do not bid. Bids will be accepted only form individual Freelancers only. DM so we can brief more on the project. Regards Arun

This project is to create: 1) REST API for data stored in MongoDB - add lists of items to the database; delete items; get data from the DB 2) Provide complete documentation with sample API calls and results 3) Implement a simple web UI that calls the API to perform each API function When applying, please describe your previous experience with: *

download my website from hosting platform to be stored on computer or memory stick

download my website from hosting platform to be stored on computer or memory stick

Looking for an experienced React-Redux developer to build a data table component that will get JSON data from an HTTP route and display the table as per the field required. Additionally, there will be fields within the table that will be editable and the table should be able to post the data back to the database to ensure it is updated with the fields entered. The awarded developer should use exis...

** Please only reply to this if you are an extremely good Android developer for complex apps. Prefer you know the K9 Github open source email app. At least download and look at it first. This job requires someone with a lot of good working knowledge and Android experience, not just simple apps. ** K9 is an open source email app available on Github. This task is to encrypt "selected&quo...

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.

...or other SQL database) - THinking of making a webpage that this links to, that just registerering the clicks and inserting it to the database. The links need to have some extra info, example invoice number, so that we can identify the replays in the database. Think this is a easy project. A simple webpage with the insert function to a sql database

HI I have a requirement and a query with me but need to run that query to show data as it ran on last Tuesday of each month for past 12 months. So for current month the logic should be as follows: When the query runs on 5 Jun 18 (1stTuesday of current month) it should store the value against month column Jun'18 as say "a" when the query runs on 12 Jun 18 (2ndTuesday of current mont...

I need help in Creating a stored procedure in MySQL with conditions. Please read the attached

Hi, I have a static html/css template (this is ready) made for a ringtones Database that I would like to connect with data stored in DB in CSV format. (this is what needs to be done) There are around ~10 fields (name, description, tag, filename) per ringtone that need to be injected from CSV DB into the HTML/PHP page. Please let me know if you have

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 would like to make a plan to build a contact lenses factory. Need to include all the following information: 1- Equipment needed (by nam...needed (by name and function) 2- Financial breakdown of all stages Start up / Design & build / operate 3- clear overall cost per lens in financials 4- factory operation proceedure from raw material to delivery

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

Stored Procedure having multiple levels of calculations in the database

Need help modifying a CSV to export its data in CSV format.

...DB from 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

I want a php based website which will fetch the data from stored procedure from another server. there are 5 pages only design is ready

We have registration portal by php where we enter registration of student. We need to add one manaul field for courses where we can add courses descriptions ...registration portal by php where we enter registration of student. We need to add one manaul field for courses where we can add courses descriptions and prices manual and finish the proceedure.

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

need a custom c# program made EXE not a website need visual studio source code project is to manage item attributes, attribute groups, and save to ms sql database. need to be able to create new, edit, delete attributes (name, value). then, need a window or section to create new, edit, and delete attribute groups. need to assign any of the attributes

I need you to develop some software for me. I would like this software to be developed. we have a CSV file with certain data in it and images are stored in different folder, looking for a script to create a webpage taking these two into one.

Hi, i have to convert SQL stored procedure to MYSQL stored procedure. please check attached sql file.

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

Laravel app: Add extra field to CSV export file using data field already stored in database

...because some code is obselete since 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 retu...

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

I would like it designed and built.