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