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 want to do the simplest ICO ever. I want to take an asset (say a painting of mine, or my house, or my car), and pledge it to a digital coin offering. Whoever owns this coin owns the asset (and all distributions from the asset - say the painting sells at auction for $1mm dollars - then all holders of coins would get a distribution of cash). So I need
...mathematically computing the orientation differences of the hands relative to each other over time and a swing, are the base core functions of the device and application. A simplest user interface would only need to be a visual representation of a pair of hands (might initially be just a pair of line vectors) basically centered on a display that accurately
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
Our business is called Connect the Dots Digital. We help CEOs and subject matter experts improve their sales ability through LinkedIn. We are creating a ...csv file with only 6 fields. Please don't let the attached description make it seem more complex than it is. I added some notes with questions, but we are looking for the simplest path forward.
I need someone who understands very well about html and php and programing languages used in websites. I have a simple selling website that I need to begin using, but can't do that until some adjustments are made there. They are: 1- I need customization to allow the following: for example, if someone wants to buy 2 items of size M of color pink and
I want to do the simplest ICO ever. I want to take an asset (say a painting of mine, or my house, or my car), and pledge it to a digital coin offering. Whoever owns this coin owns the asset (and all distributions from the asset - say the painting sells at auction for $1mm dollars - then all holders of coins would get a distribution of cash). So I
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.
About Tree-Nation “ You reforest the world The simplest way for citizens and companies to plant trees around the world. ” Tree-Nation is an open, collaborative platform where planting projects, companies, and citizens from around the world gather and work together to reforest the world. Our work is meant to bring practical and immediate solutions
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.
...response of the system for different heating tank capacity (finding transfer function of the system) – simulations in Matlab 3. Design control algorithm in Matlab. The simplest approach is using measurement data from first 10-20seconds of response and assume, that it is standard first or second order system. Parameters of the system should be found
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
I NEED A APP APP IN DIFFRENT PRIZE . EVERY DAY WIN A PRIZE. PRIZE IN WINNER GURANTED IN PUBLIC PRIZE TICKET PRIZE COST DIVIDED IN ADMIN OPTION APP REGISTRATION EVERY PERSON WITH GOOGLE EMAIL OR FACBOOK OR MOBILE NO IF ANY PERSON SHARE APP GET AND JOIN ANY PERSON PER PERSON 10 POINT WIN IF JOIN 10 PERSON GET 100 POINT MEAN RS 2 & USE IN NUMBER IN PRIZE TICKET ADD MONEY FEAUTRE ...
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.
...data is feed to a external program that returns a new control signal. (does however not look like a good solution to handle many input variables). Proposed solutions: 1. Simplest solution is likely to follow the above guides and use Ptolomy as master for the simulation. Eg. Potolomy starts the EnergyPlus simulation and uses BCVTB to for each simulation/time
...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
Hi there, We need an expert of TecDoc Data. We have Tecdoc implemantation files of our products (version. 2.4). We want to convert this files on the oth...contained there. This is needed to rewrite data into our internal system not related to Tecdoc. We don't have professional programming tools, so we need to convert to the simplest form. MS OFFICE?
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