...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 query setup ...
Data Science Related Books Build a database to collect the data science related books. You try to search for books from publishers’ websites, amazon, or even Google using the topic terms assigned to you. You will need to review the title, abstract and table of contents to make sure the books are relevant to the topic term you are assigned. Information
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.
Project Duration - 1-3 Hours Only Budget: $50 Script Type: PHP/MySQL Quality: Script must be of exceptional quality & execute very quickly Script Overview: 1) Retrieve data from 2 existing db tables on mysql server 2) Copy data into web query & execute 3) Insert a new record with the value returned by the web query into db table Script
...for the Facebook API and return the token, ad account id, etc needed to make API calls for data (these variables will be stored to a database on a central server) script/file 2: On run will use the previously obtained data from file 1 (via the database) to query the Facebook API to find the ad spend total of the previous day and return the value
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.
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 would be able to export all the data imported into a database tables. for example, I can save it on excel. Also, I want to be able to run different queries based on days or names or anything I want from the data I imported. I know it's not a difficult program and I can use excel method to import these data but I want to have my program not
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 utilizaçã...
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
...oauth or other app-specific method) the admin-level API access to multiple other SaaS applications such as Salesforce, gSuite, and JIRA. Script will query application APIs on a set schedule to download data from the apps and store it in an organized, client-specific way in a graph database. In Detail: * Backend in Golang with a modern frontend (using
...with the integration. This project will consist of the following tasks: - Install Addepar v2.14.2 with ember-cli - Link to a MySQL test database and set up the Addepar table to retrieve, group and render the data via a query - Export the working table and integrate to a custom page using the Wordpress API - Query data from the actual database in
create sockets----- server and client side and connect to database at server side and in the client side create GUI implement query to access data from database and send to client using socket
I need a query for get some informations from Ms Sql, but for privacy requirements, i can't give you access to datatabase. However i can give you two queries that working right where you can get the table names required ------ Select MGGiacDisp.Cd_AR,[url removed, login to view],cast(format(Sum([url removed, login to view]), 'N', 'it-it') as varchar(20)) AS ...
...Access file that creates reports for directory listing subscriptions. It has data in a form for an additional product I sell, but I don't currently have a specific report for some information I need. I have created a query, but I don't know how to add items to the query that are contained in the "Clients" table. I need a basic report with the
This is a Big Data & Analytics Project The task is to: 1) Configure AWS Athena to Read data from dataset stored in AWS S3 The dataset is already available! It is in JSON format, and in time-series, extracted from: [url removed, login to view] 2) Generate 3 complete SQL Queries to find out: - The highest price in the past