@Raja mssql ,

This is meant as a friendly but serious suggestion... IF you even think that you're experiencing "SQL Injection" and YOU are asking these types of questions on a...

p.s.  This would make a great DA whiteboard interview question... if the candidate only comes up with the solution to the exact problem, you might want to consider someone else....

Just in case anyone wonders what I'm going on about, the original question is a "data analysis" question.

Yep.  It can be solved without using a series of dates (and Peter's...

-- swePeso solution
WITH cteData(StudentId, delta, rnk)
AS (
        SELECT  StudentId,
         ...

jignesh209 ,

Jeffrey must've gotten busy.  Apologies for the delay.  Here's the code that will answer the question that you asked.

 SELECT StudentId
   FROM #Student
 ...

Ok, Jeffrey... the Op posted some good test data.  I'll give you the honors for providing the solution.

Sorry... I was in the process of changing my reply...

But to just identify the students that did submit on every day - all you need is the number of days to match.  Any student that has a...

• This reply was modified 3 years, 3 months ago by Jeff Moden. Reason: EDIT... please ignore this answer

Gosh... I hope you didn't take it the wrong way.  It was meant as praise with the NOT referring to the critical symbol used in this great question.

Heh... NOT a bad question, Steve. 😀

BTW and just to be sure, if you're enabling change tracking for some legal reason, it won't hold up in court.

Sure...

About the WITH (TABLOCK)... it's being used...

Although this sounds like a strange question, why are you trying to check something to see if it's a date?  If you intend to CONVERT it without having a failure,...

You do need an outer join with the dates students are expected to have turn-ins in order to accommodate a very naughty class that has conspired with each other where...

Jeff's code seems to generate primary keys and produces the correct output afaik.  Creating foreign keys should be straightforward for the OP.  The split could be accomplished with OPENJSON...