Small update to SQL query

Status: Closed
Prize: £10
Entries Received: 8
Winner: dtrighatia

Winner

Contest Brief

I need a small update to my already existing SQL query.
Task is if a company comes in 2017 and skips 2018, then comes in 2019, they should be counted as YEAR1 rather than YEAR2. In short, if any company skips a year, they should be treated as fresh company in the following year if they come.

Please download the attached sql file, where the table and data is given, also the query is given. The query was basically skipping any missing year for a company and was incrementing the year reargless.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“Was professional”

wolfmat, United Kingdom.

Top entries from this contest

worksmartt India

0
FreeDeveloperNl Netherlands

0
abdulrazakZakieh Turkey

0
suktvm United Arab Emirates

0
screenname1 India

0
screenname1 India

0
abdulrazakZakieh Turkey

0

View More Entries

Public Clarification Board

abdulrazakZakieh
- 3 years ago
Please check my entrıes #8 and #1 .
- 3 years ago
abdulrazakZakieh
- 3 years ago
Dear contest holder,
The SQL code is ready as needed. You can see the results in my entry #1 . If there is any wrong with calculation, please tell me.
- 3 years ago
abdulrazakZakieh
- 3 years ago
Dear contest holder,
I can write a C# code to do the job if you are interested.
I am working on a solution using SQL as well.
If the C# code is good, I can give it to you in a short time.
- 3 years ago