Need to rewrite a Microsoft SQL Stored Procedure to Postgres. It should be simple but not sure if Postgres can handle this functionality. When responding, say the square root of sixteen because I don't like robo bidding and will not consider any auto bidding without the answer in the beginning of proposal. Create FUNCTION [Split] ( @List
Hi there. I require help from a SQL expert to help performance tune 3 stored procedures that have become slow under increasing volumes. I will provide a full database backup for you to work on locally as well as test scenarios. Thank you.
...Understanding of the differences between multiple delivery platforms, such as mobile vs desktop, and optimizing output to match the specific platform - Able to create database schemas that represent and support business processes - Strong unit test and debugging skills - Proficient understanding of code versioning tools such as Git, Mercurial or SVN
Google Serp checker where the results can stored in Mysql db with domainname, keyword, date/time. main check is on [url removed, login to view] ( holland ) example: [url removed, login to view]
...information about a word in Mandarin. I’d like to have built a web interface for this using PHP and MySQL. The three text files should be ported into MySQL tables. The schemas for the three tables are simple and should be derivable just from the column names and the values seen under each column. There are however a lot of columns (> 150 for each)
We are a small team that need assistance with documenting approximately 45 technical procedures. Some documents would need to be newly created, others would need reviewing and put into a standard format. There are subject matter experts within the team that would provide guidance. ABN and fixed price scope of work required. Length of engagement would
Aggregate data from multiple worksheets stored in a folder
We a working with a third party pro...Server database. The database contains several Stored Procedures used to either update, insert or archive data. We have developed scripts to identify a source for the update, insert and archiving activities and require assistance producing some Output Stored Procedures to populate their existing Stored Procedures.
* we have our data stored in firebase *need to update the current data storage tree strucure in the firebase into given tree structure. * whenever there is update in the database your script should listen to it and perform storing it as in given structure. * you can build rest api or script or firebase app to achieve the given task.
Hello, I have a storage ("bucket") on Google Cloud Storage, and static files in it (.zip files, .jpeg files...). My files at this point have "public access", which means that I have a url adress, for e.g.: [url removed, login to view] and anyone can just click the link, and download the file. I want to limit this access just a little bit. I want this access to...
...database server is a single point of failure for both CMS and Efiling 2.1. Current Process and Service Currently the ITMS database system contains several schemas. One of these schemas is called Efiling and contains local Efiling data. The Efiling schema has been granted rights to read/select from the RTMS schema. It’s in the RTMS schema that the
Currently records are gathered by a web based form and saved into a Microsoft SQL database. We need a web page that allows our users to navigate though those records in a user friendly way, and it should look similar to the data input form
Requirements to the program: 1) Get the usernames/passwords stored by the Web browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Opera, edge. 2) Operating Systems: Windows 7 32-bit and 64-bit Windows 8 32-bit and 64-bit Windows 10 32-bit and 64-bit 3) Programming Language: Delphi To demonstrate the functional we need a
The website is for a business purpose. So, there is a need for good, professional work. It has to have the "extra feature" of creating a user a profile inside website and answering many questions and then storing his/her answers somewhere (necessary for business operation). It can be build in any CMS.
I need all the HR procedures that a 300 bed hospital need. As well as which of theses procedures can be automatically done from the system and what should be manually. Also the job positions that should be in the HR department with their job description.
The task is pretty simple but annoying because of the error, 2 things actually: 1. first make the attached query work, which i...annoying because of the error, 2 things actually: 1. first make the attached query work, which is just trying to create a view dynamically 2. after that do that inside a stored procedure would need within a day or less.
...500 to 600 procedures) to be mapped onto the medical conditions that can be cured by the procedure . And each medical condition mapped to an exhaustive symptoms/signs list. Each procedure should also be mapped onto its different types and approximate length of time taken to execute the procedure. On completion of all the 600 procedures , we will need