I don not know what exactly you want to do. do you want to run all of these queries or always only on of it.

This is a solution when you...

I think the easiest way is to work with a #table and an identity field.

Just take care that you have the correct sortorde.

create table #dates ( nline int identity (1,1),...