We need a MySQL Coder who can write a Stored procedure or Join Queries, I have a PHP code that is timing out so the whole logic of the PHP page has to be written in SQL Queries there are less then 6-8 tables to pull data from. The work has to be done on TeamViewer
...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.
I need some of pan card applying procedure here. Are you getting any sample for that. My projects is more lengthy and covered all types of sources about pan card. I can track the pan card application in online. [login to view URL] in this website is given form for applying lost my pan card easily. But i need some of procedure and what are the documents are needed to submit for that application. D...
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 ...
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've prepared nearly 100 different Environ...I've used multiple sources to gather the content and the result is something of hodge-podge. I need someone with a background in Occupational Safety & Health and Technical Writing to review and edit all chapters to bring uniformity etc. This is a high-priority project so I'd like to dedicate an entire team.
we are planning migrate mssql database to mysql [login to view URL] require experts to do this project and also need to suggest best architecture for mysql without downtime.
I have a project that requires the use of stored procedure in mysql. With some other Api making golang [login to view URL] 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
...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/concept). This app
I have to create several procedures in a short time, all related to the supply chain, Material and inventory management and I need someone with background in these areas to review my drafts and re-write them in an more fluent English and objectivity.
i am a computer science student learning on how to use NS2.35. I want a detailed procedure on how to install NS2.35 and tracegraph on ubuntu 16.04
I have an enormous amount of research compiled and extensive spreadsheet notes, pdfs & images. I need to simplify my pitch and sketch framework for landing pages. I have the goal of creating a decentralized solar sales force and upskilling a workforce. Website is under construction: current objectives - design and place original clip art, explainer videos and infographics. There will be man...
...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 t...
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.
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
I need you to: * rewrite the policy and procedures that i am providing and *prepare new organizational chart as i am providing old and draft new organizational charts. *as well as provide me with a workflow .
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
I need you to write a research article.' Departmental policies and procedures
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...
I need help with a simple script. Need advice and a working example of how to run a Procedure with Commit and returning a dummy result back from it. I have a example that you can reference but it is not working perfectly yet. i am not able to retrieve the result from the refcursor after i add the commit. e.g. script CREATE OR REPLACE PROCEDURE oureadata.pg_boweb_cms_category_update_v2(pid charac...
Want to use SugarCRM to conduct outbound email campaigns. We have done this in the past, but consultant who helped out is no longer available. Need to build a step by step procedure for conducting outbound email campaigns using capabilities inside SugarCRM. This involves setting up the campaign, setting up the list, building several email templates, setting up and using tracking codes (s), test...
create a plan for application department policies and procedures and team restructuring
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.
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 need a professional who can write an AML/CFT and KYC policy, programme, procedures etc. for our company. The company offers cryptoexchange platforms, trading platforms and other money-related financial services.