Hello Anthony,

First of all, thank you for taking the time to answer my question.

The reason I run the reports under Windows Integrated Security is because we have enabled some row-level...

Great, thanks so much for all you guys' help! Much appreciated. I'll try to give some karma back.

Interesting solution, though this only works if the ID's are sequential. I've tested this solution when ID's are not sequential (+1) .. Then then nid-1 doesn't work obviously.

Maybe I should...

So I'd like to take this a little further, hopefully you can help me with this issue again. So basically I solved the problem of marking records with fall within...

Thank you very much Phil for point out the LAG function.

I will post proper DDL next time.

Have a nice day.

I already made 8 tempdb files for I/O performance gain 🙂

Thanks for the replies. My second strategy is the seperation of index and data in two filegroups.

I've read in several forums and books that there is an I/O performance gain...

Well the thing is, the startdate and enddate are columns of one row.

One row looks like this : startdate...enddate...budget