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
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
...using the camera of the device should proceed with reading the QrCode of the component that needs to obtain the information. The code being read will be a primary key that will be used to query an already prepared viewer in the MYSQL database. The resulting data from this viewer will be presented to the user as shown below: The user can only consult
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 you to build a landing page. budget 600 Rs
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
...then push all this information collected to a temporary local database (can be SQLite, MySql or SQL Server Compact ???) that has to be installed automatically to store the collected information.. For each polling, beside the time of the polling, the agent will run a discovery first and the store all the collected information from the MIB using as
I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.
...create Mongodb query. It's maybe not the most complex query you ever find but we have not too much experience in MongodDB and how to use all this features. The query will cover all the basis filters and the use of the geospatial feature (just a simple search of maxdistance usign coordinates, we already have this). Basically, the query has to: Search
Hi I have a query which I use in SSRS report builder 2016 to display results in a chart. Query is ok but I would like a column being pivot in the query and have never done this before. Should be less than an hours work and your need to work via Any Desk on my system to change the query. Get in touch if you can help. Thanks, John
I have 2 Spreadsheets that I have attached - Data from these 2 spreadsheets will need to fill in the 3rd spreadsheet.
...new table off the excel sheet we run a query to capture unique values using combined Inst and Mid query to extract unique string from excel field. I am encountering a challenge that the table I create from the above query has hidden charachters (?) I only see this after I export it to a text file. I need a query value to clean this up. I have tried
i have a sum query i need that a group by field should be based on a if statement purpose = i have two warehouse's but dont want each item to show double only if its not there in the first do i want it to show from the 2nd job will be done by loggin in remotely its a query based on other query the whole structure might need to be redone should
I need a SQL expert to create a query for me that will display a category list for me in a specific format. I will provide more details to a qualified bidder. Project budget: $30 Delivery Time frame: 1 hour
I have a php page that is taking a long time to execute and in addition in some cases its timing out. I need the mysql query optimized. ** Note: Plz only bid if you can start now Give me a guideline of how you will manage to do it. Provide of how long you think it will take you For your convenience, I've uploaded the file
Looking for someone to create a simple table that pulls and displays pre-sale and on-sale events from [login to view URL] via their API. Had one created by someone using Pythonanywhere but no longer have access to it. Should be a fairly simple project. You can use any language you prefer. I just care about the end result.
This is an existing /running website built using Java, Jsp, Angular js, Query, and MongodB as backend. It needs to have My Eclipse, Tomcat 7 and JDK 7 to run, We need to enhance its look and feel and few very essential functionality as mentioned below. Working experience on any payment gateway (credit card, debit card, ACH transfer processing) would
I have a mysql query that with large data sets does not complete. I need a mysql expert to tell me where the bottlenecks are and revise to complete faster. With the largest data set, current run time for a limit of 5 rows is over 3 minutes. With all rows 9,000 plus it does not complete. Attached is the query code. I know some variables are missing
I have two queries that work individually. The first query creates a list of records. The second query selects the latest entry for each id of the first query. I want them joined so that it will operate as a single query.