Cancelled

Quick assist -Help with SQL script MS SQL 2008

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

Skills: Database Administration, Microsoft SQL Server, MySQL, SQL

See more: sql script installer net database, sql script connect database, sql video store database script, microsoft sql server migration assistant v6.0 for mysql, microsoft sql server migration assistant for access 32 bit, microsoft sql server migration assistant 7.4 for mysql, microsoft sql server migration assistant for mysql, microsoft sql server migration assistant, microsoft data migration assistant, sql server migration assistant 2016, ssma, wordpress, betfair sql script database, script ms sql jobs file, execute perl script ms sql server, create script backup database sql server, write quick web based sql database application, database sql script, converting microsoft sql script oracle database script, microsoft project help sql database

About the Employer:
( 6 reviews ) Gloucester, United Kingdom

Project ID: #16518473

28 freelancers are bidding on average $113 for this job

codetod

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

$120 USD in 3 days
(54 Reviews)
5.9
feninsoftech

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 maintena More

$133 USD in 3 days
(43 Reviews)
6.1
NourElDeen

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 in 1 day
(40 Reviews)
5.5
softcarve

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 in 5 days
(66 Reviews)
5.5
$35 USD in 1 day
(65 Reviews)
5.5
webprog4hire

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 in 1 day
(33 Reviews)
5.1
talhamq

A proposal has not yet been provided

$250 USD in 1 day
(39 Reviews)
4.7
SergioAlfaroV

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 More

$90 USD in 1 day
(9 Reviews)
4.5
AliSafder

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 in 3 days
(27 Reviews)
4.5
Agiletechstudio

Sir i read your initial requirements and i have some question regarding to your mssql script [login to view URL] can we discuss it on chat ?

$77 USD in 3 days
(14 Reviews)
4.3
schoudhary1553

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 resul More

$250 USD in 3 days
(12 Reviews)
4.4
MyAwesomeTeam

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 s More

$165 USD in 1 day
(6 Reviews)
3.7
$150 USD in 3 days
(9 Reviews)
3.9
marko04

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 More

$55 USD in 1 day
(5 Reviews)
3.9
webdev1802

Hello, I read the job details extremely carefully and I am absolutely sure that I can do the project very well. You need help with SQL script MS SQL 2008. I have an experience of over past 7 years. I have completed More

$155 USD in 3 days
(4 Reviews)
3.3
marenchuk

hello. i read your proposal carefully and understand what you need. if you hire me i will finish your task in time thanks

$155 USD in 3 days
(1 Review)
3.1
AbdulBasitAli045

hey i am a professional Developer and have A EXPERIENCE a that field kindly inbox for more details thanks

$45 USD in 3 days
(7 Reviews)
2.8
sreenivas2903

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 in 1 day
(5 Reviews)
2.8
lalope

Hi I'm not sure I follow. That value is calculated from the following expression: (([login to view URL] - [login to view URL])*@Scale)-@ReqOffset I don't see any connection with the date/time.

$35 USD in 3 days
(2 Reviews)
2.5
havar2018

Hello, there I am now testing it on my SQL Server and will get it done quickly. You are joining the same table to get the result. There might be some considerations to be taken, I think. Anyway if you give me chance More

$55 USD in 3 days
(3 Reviews)
2.4