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
28 freelancer đang chào giá trung bình $113 cho công việc này
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
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
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.