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.
...code that will determine the date/time a news article was published, from 30 top news publishers (we will provide the list), and from any publisher using the NewsArticle schema from [login to view URL] The script should accept as input raw html (that we're separately scraping) and should simply output the publishing date/time. This code must be flexible
Hi All i have a table 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
1. Remove all text and lines except the pink stamp, 3882, Mladen Rilovic and signature. 2. Change the stamp date to 17.08.2018.
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
...allow a user to check appointment availability and select the time & date for their appointment • Plugin should be fully responsive & look great on all devices (mobile, tablet & desktop), and also all browsers. • Available dates and times list will be retrieved from our MySQL database. PHP Code will be provided by me • Plugin will allow us to use ...
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 am looking for a graphic designer who can design a jersey logo for my fiance and I's wedding engagement/save the date photos. We both love hockey and are taking our "save the date" photos at our ice rink. Him in full gear, me in a jersey and jeans. I am wanting something that is cute, not cheesy, and would look good on a jersey. I am envisioning
There are 2 parts 1) Disable already selected date from the calendar 2) If user logs back in, Disable his selection of dates- his date selection is stored in a file with the name of the selected date
Hello, I simply wanted to extend date range on my existing excel sheet. When you open this excel sheet, it have provision to enter data untill 7th Aug 2018. I want this extension for 2 more years with same vendor list. I am attaching excel file.. I want its extension so that i can enter further and do calculations with filter in excelsheet...i can pay
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
There are around 300 emails that have been saved as pdfs. Please sort into the appropriate folders (given) by the month. The month you can see in the 'Date' field up the top of the pdf when you open it. Thanks!
I need a map plugin for wordpress that uses location data from rss feed from the national weather service and create a post, display the county highlighted on map, and then expire the post, removing it from the display of the map upon expiration. This information should be pulled automatically from a rss feed, and can have a cron job associated with it to run every 1 minute.
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...
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 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 [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
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.
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...
I need an iPhone app. I would like it designed and built.
Hi... I need two things fixed on my website, http:outyourbackdoor.com. #1: I would like the article date to appear at the END of my stories, not at the top where it is now. #2: The Google search button does not seem to work correctly in the mobile version of my website. (It used to work, but now nothing happens!) Please let me know that you have
I need you to build a landing page. budget 600 Rs
I'm looking to hire an analyst who can retrieve specific information from a website . This job requires gathering information from public list widely available on the internet, putting them into spreadsheets and sending them to me.
My name is John Conlin and I am the owner of Contingent Fitness Training. I want to have a wp calendar created from mysql data. Need a wordpress page to display a calendar with values from a database given a userID. This is the Query to get calendar SELECT cft_fitbitheartrateday.activity_date, cft_fitbitheartrateday.heart_zone_type, cft_fitbitheartrateday
...of a button push that filters data by date and then copies the data depending on criteria. So attached is "Book 1". It has 3 Sheets. A "Tasked" sheet that shows what work orders have been given to employees, a "Total Tickets" sheet that shows all work orders that have been received, and a "MACRO" page with date ranges for the 3 ways I'...