...lot of demonstratable experience with sqlserverstoredprocedures,
3) Including experienced with JSON functions available with SQLServer 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...

Hi
I am looking for an expert DBA to fix some storedprocedures 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 .

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

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

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.

Nautilus Data Technologies is looking for a skilled tech writer to assist in development of documents for our data center Standard Operating Procedures, Maintenance Operating Procedures, Information Security Plan for compliance auditing.
The project will last around 3 months at 20-30 hours a week.
Please visit our site at [login to view URL]

Its a project where sql queries, triggers and procedures needs to be done on a provided schema. For this task only oracle sql can be used. This is a quick delivery project therefore serious bidders only

Need to Migrate 800 Store Procedures to Migrate to Postgres SQL
Secured ODC - No Work from Home - Flexible Working hours.
[Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users]

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

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 some one to write the code for my web page so that I can Add , View and Edit data.
The page is user specific.
Sample code will be provided to see exiting auto suggestion funtionality.
Web page is already ready.
[login to view URL]

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

Biotech company needs to have its initial set of healthcare compliance policies and procedures properly formatted to ensure consistency of formatting, correct numbering via a style scheme, inserting cross-references, etc. Table of Content creation necessary as well as hyperlinking TOC. Documents consist of 120 pages. Content will be finalized next

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.

Hello Everyone,
The goal of this contest is to produce a tool to automate a manual process. The process consist in the following steps
1. Input data are billing receipts in PDF, they can be opened in Word because they ar enot images, its text and tables. All the billing receipts are saved in the same folder, the tool must be able to go to the folder and and extract the data needed from each ...