Precisamos de um especialista em SQL e Query em SQL. Temos um site desenvolvido em PHP (sem framework) onde ele realiza algumas querys em SQL. Entretanto, os bancos são BEM pesados (cada banco tem em torno de 500mb, com 2 a 3 milhões de linhas) e isso está tornando o site um pouco lento. Precisamos otimizar essas querys e o banco de dados, seja na utilizaçã...
...pontuação deles. A pontuação deles é feita assim: 1 ponto por entrega e são retirados pontos caso haja algum desvio de conduta Precisamos de um calculo automático disso em uma query Informação do folheteamento fica em 2 tabelas no BD 1 Informação das entregas fica em 1 tabela no BD 2 informaç&atil...
SELECT distinct [MISTERCHEFNET].[dbo].[Lojas].[Nome Loja] as 'Loja' ,c.[Código Vendedor] as 'Código Entregador' ,a.[Nome Funcionário] as 'Entregador' ,c.[Data Caixa] ,c.[Data/Hora Vencimento] ,(c.[Tempo Total Entrega] - c.[Tempo Preparo]) as 'Tempo Entrega' ,c.[Tempo Preparo] ,c.[Tempo Total E...
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
this project are based on SMS (School Management System) which is manage all Student record And Storing the data or information of School Department,i.e attendance, Subject record, and parents query or sending the message to student parents for complain or any query from [login to view URL] on..this is very usefull for SMS. it is developed on the PHP technology
...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 the data, no change is allowed. All data manipulations will be performed at the rear and will not be the responsibility of this project. In this scope, only one
Hello, We take over to manage a Shop System based on Magento 22.214.171.124. We looking for help on a regular bare to support this system. This project is a test task to identify this kind of help. At the moment we have the following scenario: In a Shop System, we can order EBooks (Digital Content). The price is $0 for this books. We have 10 products in
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 ...
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
The scope of the project is to replicate a single query of a java application to a .Net application. The Java application authenticates as follows: 1. User login to a website (We will provide a username/password) 2. There is a link to login to the application,on this page there i the username/token information that is provided, a JNLP file is being
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.