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 u...
...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...
Premise: Structure of Web system communicating with Webservice. HTML5 layer using Bootstrap framework, accessing Webservice layer using the framework AngularJS. The web tier will never access the database layer. This is the responsibility of the Webservice. The web tier will never have a business rule. This is the responsibility
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 do need a styled design for my family tree-genealogy. I want something fancy, feel like an "old" style, like the examples attached. The result-delivery file needs to be open, or in Adobe Illustrator, Photoshop or Gimp project, where I can add my family information and be able to print it, the width size should be 140cm. The concept needs to consider
I need someone to write a simple sql query to copy fields between tables
Detailing of steel structure 3000tonnage project , industrail structure, must be precise
Structural design calculation for a steel structure
...I want someone to create a structure for me in Spring MVC in which I can integrate my web application(won't take more than 3-4 hours for someone who knows SAML). I am not attaching the real project file but I am attaching a github link which shows the structure of my project. I want someone to: 1) Make a similar structure for SAML which shows basic
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
Hello, I have a simple project where I need you guys to make a simple downline page view based on sign in user. Which is mean Sign in user able to view their own downline tree. Currently I have made a page for admin view where admin can view all downline as in attached no 1photos. I tried to replicate the same method for user side but it not working
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
I have some work, in an Excel spreadsheet.
...Policy / Legal 7. Resources 7.1 Resource Detail 8. Roadmap 9. Community Code of Conduct Please note: Homepage structure has been complete with illustrations 70% complete. Currently looking for the following. 1. Homepage structure to be setup with, main navigation, hero banner (with illustration and motion design & development) inside elements