In Progress

Create SQL Stored Procedure

I need assistance to create a stored procedure for my SSRS project.

The stored procedure should handle the following:

1. Count the MAX number of consecutive times a certain rules are met. The rules are as follows:

a. Value is > 2 AND

b. Value is Not Null AND

c. Not Calibrating (Boolean condition)

OR

d. Value is Null

Example:

1.) 1.5

2.) 2.5

3.) 2.1

4.) 0.6

5.) 2.3

6.) 2.4

7.) 2.9

8.) 3.0

9.) 1.0

Result: 4.

Note. The datasource i'm connecting to uses the OPENQUERY command

Up for it?

Skills: Microsoft SQL Server, SQL

See more: stored procedure tutorial point, execute stored procedure with parameters, create procedure oracle, stored procedure syntax, create stored procedure mysql, sql express stored procedure, stored procedure in sql pdf, stored procedure in sql w3schools, i need to create a flyer, i need to create a design, i need to create a concierge website, i need to create a business logo, i need help create a fyler, how much money i need to create an ecommerce website, how much do i need to create a website

About the Employer:
( 6 reviews ) Cleveland, Australia

Project ID: #16939366

8 freelancers are bidding on average $22 for this job

$25 AUD in 1 day
(9 Reviews)
3.9
$20 AUD in 1 day
(2 Reviews)
2.0
daisoftware123

dear, i have gone through your requirement , i have lot of experience in sql server i can help you out in this project. Thank you for considering. Please revert me for further discussion on chat. Best Regards More

$25 AUD in 1 day
(0 Reviews)
0.0
goree

Hi Sir. I am an programmer having experience of more than 24 years in desktop application development,Convert Data To Excel. I am experienced in delphi , mysql, mssql server,access. I am also expert in database ad More

$25 AUD in 10 days
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
mahmoodahmed003

I have long term experience in database programming. I have particularly worked on SQL Server and PostgreSQL. Let me know if you want me to have this job.

$15 AUD in 1 day
(0 Reviews)
0.0
danielabino

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
ashishcompwiz

Hi, Hope you are doing well! You need us design a WEBSITE for you AS you mentioned in your description A client is very important to us. Thus our prime motto has always been to satisfy each client. Also outso More

$17 AUD in 1 day
(0 Reviews)
0.0