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 ...
Preciso que alguém crie um dropdown em meu site, em que o visitante possa selecionar datas retroativas, para ver postagens antigas. O meu site é o [login to view URL] e atualmente a paginação se encontra no canto superior direito do site, em flechas minúsculas ao lado do quadrado "Links de hoje".
Olá, Eu preciso de um dropdown para o meu site. É um site baseado em Wordpress e em Woocomerce. Irá funcionar dessa maneira: o cliente irá escolha sua atual posição e então sua posição desejada. Após isso, o preço aparecerá e ele consiguirá comprar. Eu posso fornecer maiores explicaç&o...
I have a Visual studio Form written in c++. This is for a business and i need my sales data put into text boxes on my Visual studio form. The database is already integrated and being used in the project. Thanks Aaron
I have a search form that is slow and needs optimisation.. it is also not working as expected in some cases. I need an expert in php / mysql search expressions. Site is running on Php7 and mariadb 10. I will send the search file for your evaluation if you send me a message expressing your interest.
...making some queries work. This first project is for a table that I tried to put together myself but I just do not know SQL. I have pieces but not the whole. Will lead to more query projects. Hoping to find a someone that knows Open Dental tables and can accurately build reports. Sample Open Dental Queries: [login to view URL]
Hello, I have two issues on my ionic V1 project build on ios. - I can't have vibrate plugin to work (undefined is not an objet 'evaluating [login to view URL]') - select menu are not saved when changing value I'm looking for someone who could investiguate right now Thank you
Hello, I need a sql query that generate a csv from a prestashop database, value required values in the csv are the following: id_order -> order number id_order_invoice -> invoice number total_products -> total paid of the order vat excluded and without shipping total_shipping_tax_excl -> shipping paid vat excluded state -> order state date
...goes up to say 200 the server cannot process the query fast enough and the whole server stops. Old processes are backing up and new ones are coming in faster than old ones can be processed. I had a developer add this functionality and he is no geolocation expert. He added the table and used a basic query. By what I've had a chance to read online this
...from several tables and is built to show data for the current date only. One of the select values is this session_id mentioned above. In the view, I only want to show records for the session_id associated with the current date. If I use MAX(session_id) in my query, I will get older session_id if they are the newest. If I don't aggregate this data,
C# Application Windows App (Lottery Assistant) Need someone really good with Math and C#, and number collections. I am looking to do this over the next few days, so don’t bid if you’re going to tell me this will take 10 days. It’s only about 4 to 6 hours of programming. It’s a simple win forms app. I can provide – you must use my Visual Studio 2017 project. There...
There are 3 tables: 1. Project 2. Tool 3. LinkProjectTool I need a query that lists everything in the Project table plus an extra column called ProjectTools. This column should contain a comma delimited string with all the tool names belonging to each project. The elements in this column should be sorted after Tool ID. The input data is contained
Physical Modeling Design & Structured Query Language (SQL)
...jquery that perform some specific mysql actions FOR ALL SELECTRED ROWS OVER ALL PAGES after pressing different submit buttons. When you press the main drop down menu („Mass Select Operations“) on my live example page [login to view URL] you will find all the specific submit buttons on the right, with the specific actions on the left
I need an excel spreadsheet for use by my customers, It needs to allow them to work through 6 key category choices, each category with less than 10 variables unique to category, however the last category is length in meters, so is infinitely variable I envisage the customer answering 6 questions via drop down boxes, & at the end having the cost of a cable, based on their choices. It needs ...
I want to demonstrate SQL data in a table. Picture 1 SQL query result. Picture 2 HTML table. I want to create a query which is result will be like HTML table. I mean I want to show Year column as a row and subjects as a group. I just need a query
I would like to create a select field using angular and mdc (material component)
I have a query where I am dong inner joins and then doing a check for isnumeric and then data compare that is failing as I am getting Error converting data type varchar to float. Problem is I am not sure what it is complaining about. I need somebody to help me troubleshoot the query. I am comparing to how it was working a few days ago and do not see
...knowledge about user modeling in dialogue systems required * Imagine a user that needs simple words for an explanation. I want you to create a program (in python) that can query Wordnet and find synonyms for words. There must be a function that given a word, it returns synonyms. def syn(word) will return a list of synonyms. Note: Complete commenting
Objective: To build an app that can automatically select the best quality photos out of the all of the frames taken from the continuous shooting mode camera app. This is not a research project. Requirements: Demonstrates code efficiently accessing pixel data (using Metal shaders if most efficient) and applying one industry standard method for focus
I have a software made in c++, that generate moving objects(airplane, cars, ships) with some parameters such as velocity, acceleration, position and direction. At...probability distribution. I would like to be able to determine the next velocities, positions and directions of the objects after the initial time by using kalman filter and skyline query.
I want to get detailed PrestaShop sales based on products: so the fields I want in the report are: product name | qty Sold | Average Product price | Total sold Price | Original products price | Total Orignal Price | discounted amount | available stock
...fetched: reasy_posts reasy_postmeta reasy_terms reasy_term_relationships reasy_term_taxonomy Custo Meta Key : min_product_price. So please help me out to create sql query to fetch products from tables when i put the values in the fields and sort the products through meta_value(min_product_price). For Example: Find the products 'pen' where category
...com/Beaulieu318/react-treeview-select Outline (found in repo with codesandbox links): - collapse and open each branch (This is done) - create look and feel similar (but with these extra features) as Checkable tree BS4 (reactstrap) - fontawesome 4.7 - done as example components (the actual component should not have any styling dependencies) select any node (parent
Need a query build that will execute. Needs to have Select GL number GL Id number As of date Filters of less than or equal to 3 months (0 -91days) 3 months to 6 months 92 - 180 days) 6 months to 12 months (181- 365 days) Also include balance filters MILLIONS <=$100M >$100M =< $250M >$250M need to be able to add GL numbers to With as of date
I have a 200 page book that I have in draft form and I need to 1. Advice on title for book and cover design advice 2. Query letter 3. edit and format it for print This a business book aimed to small and med sized businesses similar to this one https://www.amazon.com/Small-Time-Operator-Business-Trouble/dp/163076261X/ref=sr_1_3?ie=UTF8&qid=154111
We are a multi-brand clothing store and , from season to season, we buy clothes for the following season from suppliers. We need a query system to understand what we ordered in the past. On the basis of the request, then, we will decide whether it will be appropriate to order a particular item or not. Example: 1) We have already ordered 70 gray sweatshirts
Hello, I need to show in a wordpress page a dropdown select with some countries of the world. For each when selected display a logo, address and links (html elements). Preferable in ajax. Thank you
...a script I can run in the background of a browser (Chrome, Firefox) to track a Instagram user that blocks/unblocks me to stalk my profile. I want to be able to change the query interval (every 30 seconds - 10 minutes) and change the username. As output, I'd would like a simple log in any text format that would show me when the user unblocked me. The
We're looking for someone who can help us create a ...BigCommerce site so that a customer purchases the the correct brand, goes through the entire checkout process, and then, once payment is complete, the customer is asked to select their model number. If the model number is not in the list, we'd like a link to send us an email to take a second look.
im looking to get a csv file turned into a drop down menu like the picture or click the link to see what i mean i must be able to upload different csv files for different products must have the same layout as the one in the link [login to view URL]!#lamination=no-lamination&finish=standard-corners&size=55x85mm&paper=450gsm-silk&sided=single-sided&sets=1&quantity=100&s...
I need a fullstack developer in .net, c# , Angular 6, CSS ,HTML5, For front end and For back end Bootstrap, J query, java Ajax web API TFS. Who has good working knowledge on that and ready to work daily 3-4 hours remotely like team viwer and IST morning time in between 7 to 11am We have fixed monthly paid long term project so budget is monthly based