Find Jobs
Hire Freelancers

Quick assist -Help with SQL script MS SQL 2008

$30-250 USD

Anulat
Data postării: circa 6 ani în urmă

$30-250 USD

Plata la predare
We need to adjust certain values where there is a temporary decrease in that value for say 1-10 time periods. For example here at 06:30 the value goes up, but then in next period it goes down (which it cannot do, so 07:00:00 would need to be 1922) See attached SQL Script for how this output was generated. ALPHA LOGGER 443 18/03/2018 07:30:00 1922 ALPHA LOGGER 443 18/03/2018 07:00:00 1921 ALPHA LOGGER 443 18/03/2018 06:30:00 1922 ALPHA LOGGER 443 18/03/2018 06:00:00 1921 ALPHA LOGGER 443 18/03/2018 05:30:00 1921
ID-ul proiectului: 16518473

Despre proiect

26 propuneri
Proiect la distanță
Activ: 6 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
26 freelanceri plasează o ofertă medie de $114 USD pentru proiect
Avatarul utilizatorului
Hi, I have 10 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Microsoft Certified Technology Specialist in SQL Server. Thanks
$133 USD în 3 zile
4,9 (54 recenzii)
6,7
6,7
Avatarul utilizatorului
Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. A smaller value coming for the next period - do you think this is a problem with the data in the table, and so want to update the table, to correct data? Or you think this is some thing wrong with the query which generate the data, so we should correct the query? Since you have given only a part of the stored procedure, I was not able to figure it out completely. If required, I can connect on team viewer and check this. Look forward to hear from you. Thanks Roni
$120 USD în 3 zile
5,0 (82 recenzii)
6,4
6,4
Avatarul utilizatorului
Hi, I would like to correct the dblValue. For that i need to see the whole T-SQL. please get in touch to discuss more. Regards, Manish
$111 USD în 5 zile
4,9 (103 recenzii)
5,9
5,9
Avatarul utilizatorului
Hi there..... Warm Greetings We came along with your request for Quick assist -Help with SQL script MS SQL 2008 and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Administration, Microsoft SQL Server, MySQL, SQL We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$250 USD în 3 zile
4,8 (27 recenzii)
5,9
5,9
Avatarul utilizatorului
Hello! I am a Computer Engineer, with a MCSA SQL Server 2014 certificate, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, and overall Business Intelligence related projects and tasks. I am a near-native English speaker, currently available, and results oriented - I am a freelancer, which requires little to none supervision to deliver. I can modify the query quickly, using some or all of these T-SQL native functions: LAG, LEAD, ORDER BY, and some temporary tables. It shouldn't take more than two hours. You can contact me to help you.
$90 USD în 1 zi
4,9 (20 recenzii)
5,6
5,6
Avatarul utilizatorului
Dear Sir, you are doing the calculation incorrect, i know the correct code. I'm interested on doing your project. please send me demo data to me asap. to check my code. Kind Regards, NourElDeen
$55 USD în 1 zi
5,0 (43 recenzii)
5,5
5,5
Avatarul utilizatorului
hello i am expert in database and its hardly 1 day job for me kindly check my profile n lets discuss here himanshu
$277 USD în 1 zi
5,0 (33 recenzii)
5,1
5,1
Avatarul utilizatorului
Hi kaldien. Do you need to adjust certain values where there is a temporary decrease in that value for say 1-10 tiyou periods and adjust certain values where there is a temporary decrease in that value for say 1-10 tiyou periods ?.I can do this project as well We have experience in thoses skills: Microsoft SQL Server,SQL, MySQL, Database Administration. All my previous project was feedbacked 5 stars. because i care the customer feeling. Please text me via inbox. i very happy about that
$165 USD în 1 zi
5,0 (19 recenzii)
5,1
5,1
Avatarul utilizatorului
A proposal has not yet been provided
$250 USD în 1 zi
4,8 (78 recenzii)
5,4
5,4
Avatarul utilizatorului
I can quickly get it done. Let me know when I can start? It should not take much time. Regards, Mummhammad Ali Safder
$40 USD în 3 zile
5,0 (34 recenzii)
4,7
4,7
Avatarul utilizatorului
Hi , I could work on this and let it complete in a day , please available for clarifications , and I am expertise in sql server , so I hope that I could give 100% quality
$40 USD în 1 zi
4,8 (18 recenzii)
4,4
4,4
Avatarul utilizatorului
Hi, I don't fully understand what your problem is. As i read you have tables and it's something wrong with this query. You can show me just picture of that two tables, or send me database as you like , and explain me what you want to see as result from query. I will fix this query or i will do better one. I'm good in SQL so i thing can solve your problem. I just need to see those tables. I can solve you problem first and than you can award me. Hope to text me back. Regards, Marko
$55 USD în 1 zi
5,0 (6 recenzii)
3,9
3,9
Avatarul utilizatorului
hey i am a professional Developer and have A EXPERIENCE a that field kindly inbox for more details thanks
$45 USD în 3 zile
4,7 (25 recenzii)
3,8
3,8
Avatarul utilizatorului
Hi I'm ready for this project. I'm expert in MSSQL. Please give me an opportunity. I will do it perfectly.
$30 USD în 3 zile
5,0 (10 recenzii)
3,0
3,0
Avatarul utilizatorului
I possess expert level skills and experience SQL Server programming and I have successfully developed and implemented complex projects for some of the esteemed clients in US and Canada. I believe I can find solutions to all of your needs. Start a conversation with me today and get started to unravel the data solutions you need.
$55 USD în 1 zi
5,0 (1 recenzie)
2,4
2,4
Avatarul utilizatorului
I've worked with SQL for more than 20 years now. I've worked with almost every version of SQL Server, PostgreSQL and MySql. I have experience and expertise solving and writing complex queries and stored procedures. Additionally, I have analisys skills. I can understand business definitions and requirements easily with the corresponding documentation. I also have skills and experience designing and modeling database tables and objects, given a business model description. Strengths: - Responsible and focused - Organized - Hard worker - Analysis skills - Very proffesional - Write code documentation For further information about how I'll solve the required task, I would need some aditional data, such as table design, parameter meanning and any other info that can help me understand the business model and the task scope.
$111 USD în 3 zile
5,0 (3 recenzii)
2,4
2,4
Avatarul utilizatorului
I have deep experience in T-SQL development, debugging of queries with huge complexity. Also i have great experience in queries performance tuning.
$166 USD în 1 zi
5,0 (1 recenzie)
1,6
1,6
Avatarul utilizatorului
have the good experience on this kind of requirement...............................................................................
$155 USD în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Please check my profile. I have 9 years of experience in SQL and MSBI. I can work on this query to get you desired result. Please ping me if you find my profile suitable for this work. I have put low bid on this as it will not take much time to fix this query. I assume there is only one query which needs to be fix.
$50 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Send me table structure n query in detail
$155 USD în 2 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED KINGDOM
Gloucester, United Kingdom
4,8
10
Metoda de plată a fost confirmată
Membru din ian. 11, 2017

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.