This should be easy, but I'm not seeing it.<br><br>Say I have 100 rows in a table (or rather a result set).<br><br>Now I want to run a query that will return to me those rows in 4 groups, which would ...
Use a CTE that returns the row ID and the result of the DateDiff, then join that to your existing result set? It may or may not be faster, so as always, test it to see.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback