>>
>>can't you just order by Date ?
>
>The order by Date will give the resulting order by Date. But I need to process (the code not shown in my example) the records during the SQL Select. And I want them to be processed in certain order.
Hi, Dmitry,
I think you might want to post your code that's doing the processing, or at least give an explanation for that that processing is doing.
If for instance, you need to calculate a rolling average or cumulative sum where the order of rows is important for the aggregation/accumulation, then there are several techniques that can be done (self join, subquery, or even the new analytic functions in sql 2012)