>>>
>>>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)

I will explain in words since I have a problem creating a sample SQL Select.
Say, I have TableA (structure as of example in my initial message).
Say, I have a TableB (a little different structure than TableA but very similar, for the purpose of this example).
I want to process records in TableA and, for each record in TableA, add a record in TableB. As I process I want to Count the total of field Quantity and when the total value of processed records Quantity field is greater or equal to some variable value, stop adding records to TableB.
And as I process records in TableA and adding records to TableB, I want to process "older" records First and then newer. So if the Total Quantity value (paragraph above) hits the "limit", the newer records of TableA are not processed.

Does it make any sense? :)