Excel sql multiple query jobs

Filtro

Minhas pesquisas recentes
Filtrar por:
Orçamento
para
para
para
Tipo
Habilidades
Idiomas
    Estado do Trabalho
    5,877 excel sql multiple query trabalhos encontrados, preços em USD

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

    $171 (Avg Bid)
    $171 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...

    $19 (Avg Bid)
    $19 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...

    $27 (Avg Bid)
    $27 Média
    6 ofertas

    I am running php script on a server that puts multiple logfiles into database, which is working like a charm. So i have noticed that there is some powershell script which would need just a little bit modification to work instead of that php file. Since I am not a real powershell guy and aint going to learn it just for this script I need help with it

    $37 (Avg Bid)
    $37 Média
    3 ofertas

    ...other, they can see what the opposite person has answered? That could be the query we need to run: 1. $querystr = "SELECT * FROM `wps_formmaker_submits` WHERE `user_id_wd` = ' here there is a need to add an ID of the user, with whom you are chatting. 2. Then create a wp query and get the $wpdb->get_results($querystr, OBJECT); result. 3. Display the result

    $17 / hr (Avg Bid)
    $17 / hr Média
    8 ofertas

    For module requirement check the attached document and develop a query management module. In this development someone register for any type queries and automatically generated User ID and password for login in admin panel to post any type queries.

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

    Fix SQL Query Issue. What to fix: Need to fetch those records / rows that contains all keywords in any column in Name, Descr or OtherDesc Columns. See txt file for details. Important Note: Please read the txt file and prepare your queries if any before posting, otherwise the bid will be rejected.

    $24 (Avg Bid)
    $24 Média
    21 ofertas

    Need help in select query in MS Access

    $2 / hr (Avg Bid)
    $2 / hr Média
    12 ofertas

    Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When

    $19 (Avg Bid)
    $19 Média
    12 ofertas

    Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When

    $20 (Avg Bid)
    $20 Média
    6 ofertas

    The solution I am after requires a data engineering development which should be able to query a postgreSQL database of 20 million records (2 crores). In the ideal scenario, the query should return 100,000 records under 5 seconds. I am looking for someone who is experienced in Apache Spark and able to show a proof of concept before developing a full

    $225 (Avg Bid)
    $225 Média
    12 ofertas

    When the checkout function is used i get the error WARNING : Error while sending QUERY packet. PID in /ur/www/users/xtremezepc/[login to view URL] on line 1924 This is causing high load times when i try to check out. there are sleeping queries being created. Need fixed NOW.

    $111 (Avg Bid)
    $111 Média
    25 ofertas

    Using REACT, we want to pull in API results into HTML. We want to use a query string parameter to determine which results to pull using the API call and then display results. The goal is to have the query string parameter from the following URL pull into the API: [login to view URL] The “3828840” is the result ID that will

    $187 (Avg Bid)
    $187 Média
    16 ofertas

    ...[login to view URL] ) - Application algorithm: 1. Run a query every 30 seconds, read the records of a table with a control field = 0 2. If there are records, create two text files in a shared folder. o First file must contain some values retrieved from the query just executed. Name of file: [login to view URL] o Second File is standard (it

    $194 (Avg Bid)
    $194 Média
    6 ofertas

    We have a dealer website with a login and search ability, we want to be able to have the same search ability that is always up to date to the host site minus one column of the search results.

    $108 (Avg Bid)
    $108 Média
    26 ofertas

    I am looking for a product that can a.) receive texts and phone calls with an automated attendant b.) query a database and acknowledge accuracy then c.) send a call or text to another user. I will also require a simple database containing names, addresses and contact information. I would prefer to work with someone with which I can meet face to

    $616 (Avg Bid)
    $616 Média
    3 ofertas

    1. The program will follow XML stream where a query will be made. 2. The query interval must be able to be determined 3. The program must work as a service (and I want to test it on command prompt or other way) 4. XML is situated in a path or address like [login to view URL] (it can also be on a different pc like 10.10.10.1234:5656 / xxxxxxxxcurrent

    $1092 (Avg Bid)
    $1092 Média
    27 ofertas
    create mysql query Encerrado left

    I have a small database with 4 tables. Need mysql query to get correct data from tables. Table structure will be discussed but basically it is feed, user, school_profile, job

    $23 (Avg Bid)
    $23 Média
    41 ofertas
    Create SQL query Encerrado left

    We need an SQL query built for a hotel group. This query will be run at any date in time, to pull historical, future or combination of both to show what segmentation is on the books [to include revenue, room nights & average daily rate] We will run the query and then the attached file is how we want the data to be exported from the Property Management

    $709 (Avg Bid)
    $709 Média
    80 ofertas

    Need a little support 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: http://opendentalsoft

    SQL
    $12 / hr (Avg Bid)
    $12 / hr Média
    55 ofertas

    ...from Salesforce, excel sheets, and our data warehouse. It then does a large amount of filtering and data manipulation within Power Query and Dax, then represents the data in ~90 different report pages. We now have all of the SFDC data in our data warehouse. I need someone who can move as much of the data manipulation as possible into SQL queries to reduce

    $39 / hr (Avg Bid)
    $39 / hr Média
    29 ofertas

    Hello, I need easy access query support, I have the set of data which is in Totals Select Query. There are bunch of users with 1 line per user and 5 attributes in column. I would like to have 5 lines per every user with those attributes in rows

    $25 (Avg Bid)
    $25 Média
    7 ofertas

    ...lightweight application that will allow me to schedule sql queries and email one or more contacts if the results = , < , >, <> user defined criteria. There are 4 components to the application- 1. DB connections 2. The monitor - The monitor will be a collection of sql query, schedule to run the query, contact to alert if condition is met 3. Logs show...

    $159 (Avg Bid)
    $159 Média
    41 ofertas

    Part A and B Part-A. Basic SQL Dataset: ComputerStore The schema is as follows: ComputerStore manufacturers code, name products code, name, price, manufacturer The manufacturers table stores information about computer parts manufacturers as the manufacturer code and manufacturer name. The products table stores information about product as a product

    $20 (Avg Bid)
    $20 Média
    1 ofertas

    Looking for parttime help of person with 1+ year Query Surge skills.

    SQL
    $11 / hr (Avg Bid)
    $11 / hr Média
    9 ofertas

    [login to view URL] Is the website. Using the API key the data gets extracted every 12 hours and then it goes into database. The website should offer the functionality where i could pick the day intervals to see the change in the ranking of coins etc so the coloums on the front end would reflect the time interval i select . I could be a combination of time intervals Change in Ranking (1D,3D,7D,...

    $98 (Avg Bid)
    $98 Média
    4 ofertas

    Modify existing query to filter some results. I have a table that collects information about telecom top-ups . I need to filter out the numbers that have recharged their balance one time for a value of 150.

    $25 (Avg Bid)
    $25 Média
    40 ofertas

    I Need help mysql query optimization

    $25 (Avg Bid)
    $25 Média
    26 ofertas

    Modify existing query to filter some results. I have a table that collects information about telecom top-ups . I need to filter out the numbers that have recharged their balance one time for a value of 150.

    $28 (Avg Bid)
    $28 Média
    10 ofertas

    Need Import Forum Tables into Kunena 2.04 (Joomla FOrum Extension) with a MySQL/PHP Query or with Kunena Importer. the process complete not properly

    $54 (Avg Bid)
    $54 Média
    8 ofertas

    Need an Excel expert to help us with some data analysis using power query. Please respond only if you have experience with M & DAX.

    $168 (Avg Bid)
    $168 Média
    9 ofertas

    We have an Excel task to Combine 5 Excel WorkSheets across 100 WorkBooks that we are trying to solve with automation and the use of the Power Query Append Command. Do not respond to this project unless you can show us some actual examples of your Excel Power Query Workbooks which are working correctly. Every 2 weeks we get between 75 and 100 individual

    $138 (Avg Bid)
    $138 Média
    26 ofertas

    I am building a database for a preschool and need to calculate the children’s ages in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes.

    $64 (Avg Bid)
    $64 Média
    25 ofertas

    We maintain approximately 100 databases in SQL 2008. We need to bill each month based on the number of records added to each database. We have been doing this manually up until now. I would like to write a SQL script that will allow my (inexperienced) user to 1) Create a table in the Billing database named by the MonthYear. 2) Set a biggining/ending

    $150 (Avg Bid)
    $150 Média
    11 ofertas

    This query working SELECT DATE_FORMAT(oo.date_added, '%m/%d/%Y') as Date, ot.order_id, round([login to view URL],2) as total, round(SUM([login to view URL]*[login to view URL]),2) AS weight, round(SUM([login to view URL]*p.cost_sk),2) AS product_cost, (Select round(SUM([login to view URL]),2) from oc_order_total ot1 where [login to view URL] like 'tax' and ot1.or...

    $27 (Avg Bid)
    $27 Média
    11 ofertas

    Hello, I need to modify Powershell SQL query to retrieve multiple drive mappings. RIght now it maps drive fine only if user belongs to one group. But if user belongs to multiple groups mapping gets messed up.

    $142 (Avg Bid)
    $142 Média
    13 ofertas

    Need sql query to search database and copy random value to write row value to adjacent db column.

    $24 (Avg Bid)
    $24 Média
    26 ofertas
    Build Postgres Query Encerrado left

    I have a Postgres table with over 90 million records and trying to build a particular query in the most efficient way. PostgreSQL experience is mandatory however Python and Django skills will be advantageous. It's probably less than one hours work and urgent. So I will be choosing some one who is currently online within the next 1 hour! PS: L

    $31 (Avg Bid)
    $31 Média
    3 ofertas

    My Codeigniter web application is powered by 2 separate MySQL databases. I need a query that will query both databases individually on demand, on the fly, for each each user request, and combine the results programmatically.

    $26 (Avg Bid)
    $26 Média
    16 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)

    $22 (Avg Bid)
    $22 Média
    17 ofertas

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

    $28 (Avg Bid)
    $28 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

    $25 (Avg Bid)
    $25 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

    $64 (Avg Bid)
    $64 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
    $102 (Avg Bid)
    $102 Média
    27 ofertas

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

    $82 (Avg Bid)
    $82 Média
    34 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

    $182 (Avg Bid)
    $182 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

    $12 / hr (Avg Bid)
    $12 / 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

    $6 / hr (Avg Bid)
    $6 / 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

    $6 / hr (Avg Bid)
    $6 / hr Média
    35 ofertas