Posted by jim_geissman on 11/03/05 21:52

kalikoi@gmail.com wrote:
> Hi David Portas
>
> If order by doesn't work then how can i frame my temp table so that i
> can work on Jen's query
>
> Hope u got my requirement
>
> thanks & Regards
> kalyan

Lacking a date column, you could add an identity (or timestamp?) column
that would track the sequence in which rows are inserted. If the
business
process causes rows to be inserted in chronological sequence, this
column would allow you to identify rows from consecutive days for a
given ID and determine their place in the arithmetic.

[Back to original message]