Small sql query jobs

Filtro

Minhas pesquisas recentes
Filtrar por:
Orçamento
para
para
para
Tipo
Habilidades
Idiomas
    Estado do Trabalho
    6,324 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...

    €150 (Avg Bid)
    €150 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...

    €17 (Avg Bid)
    €17 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...

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

    The project is using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really e...using PHP 5.6 the work is near taking 2 hours to solve this issue. convert this whole project to 5.6 to 7.2.1 it's a really easy task just because I am using atom so just 3 query to convert the whole project.

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

    I want to extract some data via PHPmyadmin from a database in a CSV format. only apply if you are an expert and can do this right now. I think its small task and it can be done within 5 min if you understand my requirements. Need to be done on anydesk.

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

    Need some strong Jquery developer to set over flow issues, already we used horizontal scroll need to set overflow for one sections, will give more details.

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

    alter table [login to view URL] if the following cols dont exist add z_rech_code string 10 chars z_suc_msg string 100 chars z_min number like 999999.32 z_warn integer 2 dig default 1 Z_tries integer 2 digit default 0 z_last_topup_date date z_last_topup_run date default is create date z_enabled 0 or 1 z_ussd_1 string up to 100 dig z_ussd_1_return string up to 100 z_ussd_2 string u...

    €175 (Avg Bid)
    €175 Média
    8 ofertas
    Modify SQL query to MDX 3 dias left
    VERIFICADO

    We have a stored procedure with sql queries , need a person to help us converting it to cube and get the desired output. we have the dimension and measures are in place

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

    Hi there, My IT person is away on holidays and I need someone to help me with 6 simple queries. Very simple task is to write 6 SQL statements based on a simple data model (4 tables only). Easy for a very good SQL programmer, should take less than 20' of your time! Details of the model and the 6 questions to be shared privately after project approved

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

    Hi friends - I have this syntax that I am attempting to query an API and return data from it. My issue is that when the syntax hits List<IH> ih... line it returns a 500 error. Can someone examine this and let me know what I should do to remedy? private void LoadGrid() { List<IH> IH = new List<IH>(); IH = dal

    €34 (Avg Bid)
    €34 Média
    12 ofertas

    NEED SOMEONE TO HELP FIX SQL DATABASE QUERY (Load directions: 610 directions)

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

    ...1.1 Query/Search - "leaf" View Search History - Live Example: [login to view URL]~%3A=PARA1%24LD&expr=PARA1+AND+PARA2&p_s_PARA2=leaf&p_tagrepl~%3A=PARA2%24COMB&p_op_ALL=AND&a_default=search&a_search=Submit+Query&a_search=Submit+Query

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

    Please write sql statement to query “total sales of each product for each salesman who had sales on more than 1 product“ check files

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

    ...iis and hosted in aws and in AURORA db. The scope of work includes running benchmarks tests, analyzing the results and improve the query performance Till acceptable performance level is achieved. This is no simple sql writing job. Need high level expertise in understanding complex queries and rewriting them to improve the performance. Please share

    €469 (Avg Bid)
    €469 Média
    48 ofertas

    Need to be able to semantically parse queries to classify textual queries into buckets and translate them into actions to perform. More information if we decide to proceed.

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

    I need to make 10 queries on MS-Access, are multitable query. And very important, I have a table with User and password. Need to show information if user and password is valid, if not valid the query not show information. I want to the freelance will connect to my machine to make queries.

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

    The PHP needs to: Check a date field then email me (a designated email address) and a client (their email is in a table in same database) on that day. Email to say something like "Just a reminder." with a subject of "(field in database) Date" and also Check a second date field then email me (a designated email address) and a client (their email is in a table in same database...

    €117 (Avg Bid)
    €117 Média
    26 ofertas
    MongoDB Query Help Encerrado left

    I would like some help with some simple MongoDB queries. Message me for more info!

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

    SQL Query for an existing database

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

    I am looking for someone to write an Excel / PowerBi power query to allow me to access a text analysis API provided by Tisane. The API documentation can be found here: [login to view URL]

    €85 (Avg Bid)
    €85 Média
    12 ofertas

    I need to solve a json_decode query (PHP, using curl_setopt). The php file will be hosted in a URL without HTTPS, but the data provider had HTTPS. The code is attached here.

    PHP
    €90 (Avg Bid)
    €90 Média
    15 ofertas
    Custom search query Encerrado left

    ...Project Manager to a page in a table format with a link to additional information in a profile page. The Project Manager has a search and query search but the search does not work. I want to be able to input a query based on the following fields in the table: class year, position, ht, wt, state/region, gpa, act. Any assistance that you can guide me

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

    Can someone fix my C# syntax to query SQL Server from ASP.Net? This is my syntax I attempt but I have multiple compile errors -> what would be the proper way to do this? public class InvoicePullController : ApiController { public IEnumerable<Invoice> Get() { List<Invoice> result = new List<Invoice>(); using

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

    Hi! I want hire someone who can write one small query and one small function which can provide me required data in table. I have one table called number_list in which I have id, name, number and one another table called number_status in which I have id, number, start_time and end_time. I want display data in my table called name, number and Number

    €2 / hr (Avg Bid)
    €2 / hr Média
    8 ofertas
    Facebook Group Query Encerrado left

    I belong to about 30 Facebook Groups. I have about 10 products that I post for sale to each of these groups . I need a Program that can identify all my Post Id's in all my groups. The ID's can be saved to a text file. I own a Windows 10 laptop. If you can't write a program for my laptop, then an app for my samsung s9 android phone would be my second choice. If you could tell me how ...

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

    I have a small android game project with firebase analyitcs and I need to get the data from Big Query wich is using SQL language so I need someone to create some simple tables for me.

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

    Calculate the Credit transaction views for each month, per customer. CreditView - In the form 1-0-0-1-1-...etc where 1 is a month with at least one transaction and 0 a month with no transaction CreditVolumeView - In the form 2-1-3-0-1-..etc where each digit is the total volume(number) of transactions for one month CreditAmountView - In the form 128-29-24-89-...etc where each number is the total ...

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

    I am looking for someone to transfer excel data manipulation logic into Microsoft power query (Microsoft power BI) to enable assessment of a large data set (>200m rows).

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

    I am looking to create a query the links two columns in the same table and considers them as a single row when running the query. This needs to ensure that column 1 ('action') and column 2 (availability_date) both equal the value listed. We have multiple entries where 'user_id' in this database table, which has matches for the action and availability_date

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

    Using Entity Framework and C# want to run a Select statement Stat...studphone from studeninfo where validated IS NULL Need full C# syntax that can query SQL Server using Entity Framework and execute the above select statement. I already have set-up Entity Framework and am returning all results from table, just need to know how to do a raw sql query

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

    I want to add query to retrieve data from other MySql database in same server to Joomla website using login user condition

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

    An existing stored procedure which is having sql queries we need to update the sql queries to MDX.

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

    ...medium). Site's working fine mostly, but sometimes the server CPU utilization shoots up to 200% (2 cores) because of one mysql query. On setting up a slow_query log and testing with few orders, there's this particular query which takes the most time. SELECT c.category_id, c.parent_id, [login to view URL] as title , ( SELECT COUNT(p

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

    AppGini knowledge a plus! I have a database which houses several tables, consisting of employees, their titles, and what brand they work for. I then have a table which houses various training programs and another that lists which training programs are required by which brand and for which position. I need a report that will display what training is required for each employee based upon which bran...

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

    I have a MongoDB query: var queryLookup = {from:'fromCollection',localField:'field',foreignField:'otherField',as:'lookup_info'} [login to view URL]({$match:queryObj},{$lookup:queryLookup},{$project:queryProject},{$sort:sortObj}).toArray(function(err,items){}); However, the lookup_info value is an array with the first element being the entire set

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

    ...another and discovered an issue with duplicate images. Some products call images like abcd_01, abcd_02, abcd_03 but it's always the same image. We want someone who can script a SQL function or a PHP script to make the product call abcd_01 for all variants or for all other products which call abcd_02 and abcd_03 and so on. But, obviously, we have 61637

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

    Please see excel spreadsheet attached- it has 2 tabs. Tab 1 – Jan-Sept –Lauren info Tab 2-AB vins unpaid –Andre info I need to populate column H of my tab with description “AB list.” as per the VIN and part number in his spreadsheet-column C and D on his tab The ones in yellow on his spreadsheet I did manually & populated column H on my spreadsheet by typing in...

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

    I'm providing you with a UML diagram (see attachment and the note below) and the following question based on which a SQL needs to be written. The Question is, Which Drugs are in a relationship with a Gene that is in a relationship with a Protein which has a relationship with another Protein where minimum positivity is 0.8 and minimum identicality is

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

    I need to take out matching records from sql server saven in key and value pair. Key can be anything like "Masters in Maths" etc and value can be anything like "90%" for example. I need to take out all records when i pass "Masters in Maths" as query parameter.

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

    We have a map application with a Laravel website. The GeoHash has been implemented and there's small issue with it. We need you to fix it. If you know Open Layer or Laravel programming. It should be easy. The work has to be done using remote control: Teamviewer or Anydesk.

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

    Looking for anyone with knowledge of dbf files

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

    Hi, I would like you to create a sample Java application that can continuously listen to any addition, modification, deletion that we do on a sp...you. PS: Note if you are proficient with PCF and binding multiple internal and external services, Spring boot, maven/gradle and ofcourse Java/J2EE, I could have continuous small projects coming your way...

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

    ...give me correct answer. Please don't bid more! Query 1: select date_format(livedate,'%Y-%M') as month, sum(allotted) as made_available from sky_seat_detail s, sky_film f where [login to view URL]!='backstage' and f.live=1 and livedate>=live_date and s.film_id=[login to view URL] group by month order by livedate asc; Query 2: select date_format(live_da...

    €12 (Avg Bid)
    €12 Média
    28 ofertas

    I have one SAP report called ZAR AGING and this need to convert in SQL procedure. So I am looking for an expert who can read the logic from SAP and convert it in SQL query

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

    I will inform you with a detailed explanation and source of the chat.

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

    We need help writing an SQL query for Microsoft access. The calculation that I would like to perform is on time series data. The query selects data from the table (see attached file) related to a single unique identifier (CUSIP) and then performs a rolling calculation for the Variables PosShare , Cost, MV and G_L (see example calculations in attached

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

    Hello there, On Mongodb, a filtering query will be printed using aggregate. You'll certainly be giving details of mongodb function while not reaching the expert friends on mongodb aggregate queries to be printed without sacrificing performance by using aggregate.

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

    small query on php all details on private

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