You will be given the a [url removed, login to view] for macaddress,timestamp,locationid of every single timestamp entry You wi...assume that he/she stayed for 5mins that location. if the diff of the 2 timestamps > 5 mins you should take 5 mins of the end of the query time. There will be exact results that is calculated manually. We wish to use SQL to make it easier.
I am looking to do a Outlook plugin that will integrate with another system via REST. I will give you the needed REST API to do your part in outlook.
...exports a daily XML file that contains the session times for each cinema. We would like a Windows application that checks the system clock every minute, and uses that time to query the most recent XML file in the specified directory to check if there is a session that is starting at that time, and if so, call the announcement script. If there is more
...modify the SQL Query sql://select if(LEFT('#cli#',2)=CLI,'BLOCK#number#','out#number#') from block_caller_id The above is set for first 2 numbers, we would like to set this for 2,3,4,5,6, or 7 numbers Also we want the table with these numbers to be imported from a CSV file and this to be done automatically you can see the initial qu...
I'm looking for someone that can change the syntax of an Oracle SQL query to Teradata SQL (query attached) The work will be paid fully if the query runs correctly in Teradata (I will attach the screen as an evidence if it's not running). Please don't submit any solutions without having accepted the job previously because I will not read them....
I'm looking for help . A guy who has very good expertise in SQL Server 2016 Columnstore indexes, Partitioning data and who can fine tune indexing for query performance. We are talking about FACT tables with billions of rows.
I want to make a windows software project that search for a pattern of a in image inside database of images, Also video tutorial step by step to discuss implementation. using C++ & opencv & any thing else. Example: Search for person inside database of images.
We have 18 HTML email signatures that need to be coded so as to work on any version of outlook. The image link will be sourced from a server. We need the signature to work correctly no matter from which version of Outlook it is sent or on what device it is viewed. The HTML and designs have already been done but we need for it to work well once sent
I have built a travel website where people can buy tours and make reservations if they want. If they don't pay until 04:00 every day, their reservations will be deleted. The reservation system is already done. But they stay there if we don't delete them by hand. I would like to have a scheduled job for deleting unpaid reservations (unpaid reservations are indicated with a different state...
I need my email outlook configuration set up properly. All of a sudden not all but some of my emails go to peoples junk folder. It never happened before just started. One in particular is the same domain address that I send it to and it goes into junk. People who I send often too, goes into junk even when I hit reply to that specific email. My
I want to create a group email that i can add and subtract people from. However, when I send the group email with text and/or attachments, I want it to go out as an individual email so that the recipient thinks their email is not part of a group...hope this makes sense ..
I'm using .htm Signature in my outlook which looks good when view in PC/Laptop but if open same in phone or tablet it don't display as responsive means it don't become vertical layout rather it show same as PC version horizontal. So looking for someone who can make it responsive quickly.
Precisamos de um especialista em SQL e Query em SQL. Temos um site desenvolvido em PHP (sem framework) onde ele realiza algumas querys em SQL. Entretanto, os bancos são BEM pesados (cada banco tem em torno de 500mb, com 2 a 3 milhões de linhas) e isso está tornando o site um pouco lento. Precisamos otimizar essas querys e o banco de dados, seja na u...
Hi, I have a query function in a column that gets a currency exchange value from a date in column A. I would like a script that overwrites the query function in this column and control pastes special values of the data when the query function has been activated. The reason for this is there are about 40 entries per day in this column. Ive noticed