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
...person to perform penetration testing of our web site. this is the scope of work This is very urgent. Scope of Work. The Freelancer will perform an Application Penetration Testing to identify vulnerabilities in applications residing on Customer’s networked systems that offer user or inter-process interfaces, such as web applications and “thick&r...
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 setup basic environment with guidelines to do the rest of the settings myself. --Setup Elasticsearch 6.3 Full Stack Environment Setup local ELK development environment, later will move it to AWS Cloud --Create Index Create sample index for few documents. I will provide sample data in jSon or CSV format
I need someone to write a simple sql query to copy fields between tables
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
...computer or a web application tool) which will be able to do the following: 1) User will be able to import bulk keywords line by line (using a text file or direct import into the software). 2) The tool must take each keyword and run a query in Google with "allintitle:keyword". 3) Google will return a number of results from the above query. For example
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.
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...
...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 it seems to be the issue. I need a quick