I have a CSV sheet w/ all the appointments made at different locations which have the client ID number. I would like to take the client ID from the appointment table and match it with the Client Table to find out their name, number and email and which location they booked at.
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
I need someone to write a simple sql query to copy fields between tables
I need someone to help me to set up a migration project by teaching me how to do it with a couple of forms. I already did the frmf2xml but for some reason I can´t continue.
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
Hi, I need help with database import and datapump. I need someone who can start urgently. I will share details shortly. Regards
Hello i need to Make integration Between Oracle Rightnow and Avaya (CTI)
...Grab the data on a scheduled basis 2. Be able to download the file in CSV format and save to a folder on a scheduled basis 3. Automatically load it to a target table in a Oracle SQL database This is a test project, and if successful and quality work is done, there are several similar projects that would be awarded and long term work available. The
The project is: Install a Oracle 11g database in a fresh CentOS 7 server (ssh only and database files should be located on home folder) Configure backup in other folder Run a backup in other Oracle 11g running on AWS Restore the backup on the new server Test and simulate 500 users on this system Resuming: install Oracle 11g and migrate a old installation
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
I am working on Oracle ICS Integration. I have 2 SaaS Cloud Instance and need to migrate data from one instance to another using ERP/Sales cloud adaptor. I have already established the connection and activated the Instance however ICS Instance is not getting triggered when I create an Item in Source Instance (I am using Business event to Trigger Import
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
I am looking for an illustrator who wants to have his name put on my deck of divination cards. The copyrights will belong to me but the artwork will be attributed on every copy sold to the illustrator. The project is strictly budgeted so it is better suited to illustrators who are looking to put their name out there. Familiarity will ancient Greek mythology and ancient Greek vase art will be helpf...
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [kirjaudu nähdäksesi URL:n], SUM([kirjaudu nähdäksesi URL:n] * [kirjaudu nähdäksesi URL:n]) as price FROM Customers INNER JOIN Invoice ON [kirjaudu nähdäksesi URL:n] = [kirjaudu nähdäksesi URL:n] INNER JOIN InvoiceDetail ON [kirjaudu nähdäksesi URL:n] = [kirjaudu nähdäksesi URL:n] group BY [kirjaudu nähdäksesi U...
I have a request table I need a few queries done on. This is an excel sheet. I need to find out quick analytics on our user behavior. It would be excellent to get the %, numbers and graphs depicting results.
Hi, I need to upload data from an excel to a database by creating a new table, and from there transfer some data to 2 sql tables from that database. More details in the attached excel file. Cosmin
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...