Small sql query jobs

Filtro

Minhas pesquisas recentes
Filtrar por:
Orçamento
para
para
para
Tipo
Habilidades
Idiomas
    Estado do Trabalho
    6,197 small sql query trabalhos encontrados, preços em EUR

    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...

    €145 (Avg Bid)
    €145 Média
    17 ofertas

    ...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...

    €16 (Avg Bid)
    €16 Média
    13 ofertas

    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...

    €23 (Avg Bid)
    €23 Média
    6 ofertas

    I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required) for this.

    €22 (Avg Bid)
    €22 Média
    11 ofertas

    I have 8 custom T-Codes by whic...SE93). I need you to replicate exactly the code that is represented by the SAP Report as an end product being a standard SQL query. I have direct access to the underlying tables through an ODBC connection, and therefore need to have SQL queries constructed that replicate exactly the logic built into those SAP reports.

    €960 (Avg Bid)
    €960 Média
    26 ofertas

    Hi, I need some SQL query line work outsourced for my company. Must be done right away.

    €24 (Avg Bid)
    €24 Média
    6 ofertas

    1 step : need help creating ajax query to send and receive json data with multiple data 2nd step : need help to create php script that receive data send using ajax query and call another php script 3rd step : call another php script to perform specific function from another folder 4th stpe: send output back to web page 5th step : need to make sure

    €21 (Avg Bid)
    €21 Média
    7 ofertas

    Hello, I run a Wordpress store with Woocommerce. I want to display a top 10 sales charts of "recent" sales on a page. I'm looking for a custom script / query to display a vertical list of the 10 products that sold the most copies in the last 30 days (like a current top sales charts). I would like to have it usable via a shortcode, so that I can display

    €55 (Avg Bid)
    €55 Média
    6 ofertas

    ...need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field. Any amount of text could exist before or after the pattern that's shown. I should be able to add Where clauses to the query to filter the dataset that's used for the query. Example:

    SQL
    €85 (Avg Bid)
    €85 Média
    24 ofertas

    BIDS OVER $100 WON'T BE HIRED. VIDEO INSTRUCTIONS = [login to view URL]

    €70 (Avg Bid)
    €70 Média
    35 ofertas

    I am looking for googlesheets integration with the eventbrite api. I would like to be able to run a query like this: [login to view URL] and have the results returned into a googlesheet with each event

    €154 (Avg Bid)
    €154 Média
    10 ofertas

    Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €10 / hr (Avg Bid)
    €10 / hr Média
    28 ofertas

    Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €5 / hr (Avg Bid)
    €5 / hr Média
    11 ofertas

    Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €5 / hr (Avg Bid)
    €5 / hr Média
    35 ofertas
    SQL Query History 22 hours left
    VERIFICADO

    need to find out how to view sql query history that shows who ran the query, how many records affected, where it was run from etc..

    €36 (Avg Bid)
    €36 Média
    19 ofertas

    I need some changes to an existing website. I already have a design, I just need you to build it. I would like a query display on a page that shows current unpaid customers.

    €78 (Avg Bid)
    €78 Média
    16 ofertas

    I need a query to activate "Status Stock" In stock on all my products Type: Configurable Product Issue: There was a load of products but the Options Status Stock is Out Of Stock and it display the products on the front "Out Of Stock" even when the variables has stock on it.

    €45 / hr (Avg Bid)
    €45 / hr Média
    26 ofertas

    I am looking for someone who can create a form with multiple inputs ...a column in a table. - the values for the drop downs will also be from a column in a database table. Once the form is created, it will need to work as a search "system" to query a table in the database and display a table with the returned values. Using AJAX, PHP, JavaScript etc!

    €24 (Avg Bid)
    €24 Média
    24 ofertas

    fdhgfdhdfhgfhgfgbncbncv cv cbgfhgfh fhgf hfgh gfh fhfh

    €18 (Avg Bid)
    €18 Média
    3 ofertas

    API Using the [login to view URL] POST /rest/catalog/productsstockbyreference We need to generate a simple XML based on multiple SKU query. This will then be imported into WordPress daily. This is a temporary measure until a full connector has been built by our third party.

    €158 (Avg Bid)
    €158 Média
    13 ofertas

    I need assisted with Power Query. I have a project to create a Query that will allow me to pull data from Q1 and Q2 and print quarterly reports.

    €30 (Avg Bid)
    €30 Média
    13 ofertas

    ...================================= Experience and Skills Required to use our IDE (Berlin, Tokyo) ========================================================================= MS SQL, FireDac, ADO, Parameterized Queries (this is a must) Dev Express Components (this is a must) NSoftware, CData Enterprise Adapters, Rest API (this is a must) ===========

    €11 / hr (Avg Bid)
    €11 / hr Média
    19 ofertas

    The problem is that part of the query is passed from another file. I think it will be easy to fix

    €26 / hr (Avg Bid)
    €26 / hr Média
    22 ofertas

    I need someone who can write me a Query for PHP/MYsql to update 2 tables, I have about 5 warnings in error_log file after upgrade to PHP7.2: count(): Parameter must be an array or an object that implements Countable (2x) Illegal string offset 'content' (: eval()'d code) array_key_exists() expects parameter 2 to be array, null given count(): Parameter

    €132 (Avg Bid)
    €132 Média
    41 ofertas

    ...two pieces of a WordPress project: 1. First off, I need a custom post type query ordered by a custom field. Both the post type (events) and custom field (start date) are created by the EventOn plugin. The event start date field appears to be stored in UNIX format. The query is already written, we just need it sorted by the custom field. 2. Secondly

    €352 (Avg Bid)
    €352 Média
    33 ofertas

    Need Help in SQL Query in order to get proper sequence number.

    €11 (Avg Bid)
    €11 Média
    77 ofertas

    On savesnote click I want to add Orderontes to Ordernotes table using AJAX and also save it to database without refreshing the page.

    €14 (Avg Bid)
    €14 Média
    4 ofertas

    ...DNS query to a single specified DNS server (the function you create must accept the IP address of the DNS server as a variable) to lookup a specified domain (again the function must accept the domain name as a variable). The application must compile under gcc version 4.8.5 with -std=gnu++11 or it will not be accepted. After sending the query to the

    €149 (Avg Bid)
    €149 Média
    15 ofertas

    I need to do a query with cypher to merge nodes with the same property and create a list with another properties not unique

    €36 (Avg Bid)
    €36 Média
    2 ofertas

    Necesito crear un query que busque en los meta de la orden rangos entre dos fechas.

    €17 (Avg Bid)
    €17 Média
    2 ofertas

    report page works. [login to view URL] we need the html mess removed. and css put in. simple row output. we need a search box for company / url only. we need a status sorted link to work. view code before bidding. will block those who don't read description before bid. want it done right now. not waiting. don't bid. new york time zone.

    €36 (Avg Bid)
    €36 Média
    6 ofertas

    Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Project Overview: Find & Replace query to replace a string of text in one db table based on two sets of criteria. We have tried to use the phpadmin find & replace function but it can't seem to find the required text YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK

    €8 / hr (Avg Bid)
    €8 / hr Média
    15 ofertas

    Hi, I have a defined table schema and a data set in excel. my project requires me to design the SQL query which will give the output as the data set. For someone who knows SQL query, this should be 10 minutes tasks.

    €13 (Avg Bid)
    €13 Média
    65 ofertas
    €20 Média
    16 ofertas

    Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Project Overview: Find & Replace query to replace a string of text in one db table based on two sets of criteria YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU

    €6 / hr (Avg Bid)
    €6 / hr Média
    19 ofertas

    YOU MUST BE AN SQL EXPERT OTHERWISE PLEASE DO NOT WASTE TIME BIDDING. I need occasional help with writing very short, simple and basic SQL queries to extract data from a database. Its mainly for SQLite. I just need the queries to be written. If the price is right it will be on a regular basis (for an SQL EXPERT the queries needed are very simple, very

    €3 / hr (Avg Bid)
    €3 / hr Média
    16 ofertas

    I retrieve google spreadsheet in this way: [login to view URL]{key}/pub?{gid}&single=true&output=csv but then my problem is it doesn't update instantly as data changes. (It takes approx. 5-10mins randomly) I want a solution on instant changes of my google spreadsheet data to a cloud csv with an url

    €3 / hr (Avg Bid)
    €3 / hr Média
    8 ofertas

    ...example: [login to view URL] Plugin zip file here. [login to view URL] Takes 2 minutes to setup (please delete when finished) PAGE 1: $10 file name: [login to view URL] IMAGE: mobile image QUERY PAGE1 Nothing fancy just a list with some css styling to match example: I use to see quick list of clients and website on iphone. needs to be responsive and prettier than example

    €17 (Avg Bid)
    €17 Média
    8 ofertas

    I need a SharePoint form created in InfoPath that can query and display results of a second list when the second list field meets a certain criteria entered in the form. The list items that meet the criteria will also need to have several fields updated from within the form using workflow. This is a vanilla SharePoint 2010 Enterprise server with

    €143 (Avg Bid)
    €143 Média
    24 ofertas

    ... Takes 2 minutes to setup [login to view URL] (please delete when finished) PAGE 1: $10 file name: [login to view URL] IMAGE: mobile image QUERY PAGE1 Nothing fancy just a list with some css styling to match example: I use to see quick list of clients and website on iphone. needs to be responsive and prettier than

    €25 (Avg Bid)
    €25 Média
    1 ofertas

    ...example: [login to view URL] Plugin zip file here. [login to view URL] Takes 2 minutes to setup (please delete when finished) PAGE 1: $10 file name: [login to view URL] IMAGE: mobile image QUERY PAGE1 Nothing fancy just a list with some css styling to match example: I use to see quick list of clients and website on iphone. needs to be responsive and prettier than example

    €24 (Avg Bid)
    €24 Média
    9 ofertas

    This is a simple and small project. You have to write a job which runs on Windows 2012 Server Task Scheduler. The job starts at a time specified in some file. The job fires a query on the MySQL database and fetches the resultset. Our developer will give you the query and take care of the steps after that. We should be able to specify when the job auto

    €23 (Avg Bid)
    €23 Média
    9 ofertas

    Hi I need to be able to list all the email addresses both primary and alias that exist in a domain (Exchange 2010), and place those into a SQL Server table. I would therefore like a powershell script that populates a table with: Username, EmailAddress, PrimaryOrAliasIndicator. The script will be run as a scheduled task once per day. Therefore, it

    €31 (Avg Bid)
    €31 Média
    4 ofertas

    i need to do a mysql query where i have 3 tables: users -id veiculos -id veiculosremovidos -user_id -veiculo_id so now what i need is to query all on the table veiculos removing the ones that a especific user have removed so if i have in the veiculosremovidos (user_id=1, vaiculo_id=7800) it is not listed, i can explain in detail in chat

    €20 (Avg Bid)
    €20 Média
    26 ofertas

    I have a complex SQL Server query that needs a performance improvement. The query is the return of a function (ie, the function returns the query statement). I think that performance improvements on this query should be: indexes to be created on tables involved and create one or more indexed views (I know there are limitations, specifications and commands

    €107 (Avg Bid)
    €107 Média
    17 ofertas

    ...according to them we would like to perform calculations and display results. I'm looking for a developer who can help us "convert" complex Excel formulas into a php / mysql query or other Ajax / Jquery (we are open to any solution) In the attachment Excel document, you will find 2 tabs. - data: In column A "Balance", this is the dynamic data that

    €118 (Avg Bid)
    €118 Média
    27 ofertas

    looking for someone who is fluent in magento and can help change and optimize a few sql queries.

    €108 (Avg Bid)
    €108 Média
    35 ofertas

    Hi, I need mySQL query for database is Magento 1.9, I need select attribute from table: catalog_product_flat_1 sales_flat_invoice_grid sales_flat_invoice_item Last 10 Invoice one random product, costumer name, Country, product name, Time (h), image path, product link. I need only Query like this: SELECT * FROM sales_flat_invoice_item, sales_flat_invoice_grid

    €30 (Avg Bid)
    €30 Média
    21 ofertas