I currently have a couple of Microsoft SQL procedures that was written for me and although it works it takes an extremely long time to run 1+ hour. It is a repetitive script that does a lot of checking through though a long table 12M records. I believe I have optimized indexes but think the task could perhaps be optimized by breaking the search down
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.
I need help in Creating a stored procedure in MySQL with conditions. Please read the attached
I need some help with writing a patent.
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 have a fictitious medical murder procedure describing an encephalectomy for illegal organ harvesting and need it translated from English to Russian. Machine translation will not be accepted, and I speak sufficient Russian to look for evidence of this. As mentioned, this procedure is fictitious and is to be used as a clue in a murder mystery game I'm
...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. 2) faults data: this is the data they send when they generate
...creating an alternate reality game to simulate busting an international human trafficking ring, a portion of which involves investigating medical murder. Students will review a procedure for harvesting human amygdalae and other brain tissue for bio medical research with the goal of producing enhanced cognitive speed. Using medical diagrams, I have cobbled
Need help modifying a CSV to export its data in CSV format.
Create Store Procedure Visual C# .NET from Windows Server to Modify data in Mysql Database runing in Linux Server. Simple Test select and update data in mysql. pass parameters by console.
Create Store Procedure Visual C# .NET from Windows Server to Modify data in Mysql Database runing in Linux Server. Simple Test select and update data in mysql.
...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 am looking for someone with a legal background and experienced in US tax filing. More precisely, I am seeking advice for the Domestic Streamlined Procedure (form 14654).
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.