Posted by bevanward on 10/02/73 11:50

Hi Mike

I have read fondly of row_number() in 2005 and can't wait. This has
existed in Oracle for years, from what I understand, and I'm not sure
how we have done without it for so long.

I have re-written the code for this and it doubles the execution time
unfortunately.

Thanks again for taking the time, most appreciated

Bevan


Mike C# wrote:
> <bevanward@gmail.com> wrote in message
> news:1150342841.281994.283570@u72g2000cwu.googlegroups.com...
> > Hi Mike
> >
> > Thanks for your comprehensive response. I had always assumed that this
> > insert was dependable (sequential and contiguous) ... I guess I need to
> > go back and re-write anywhere I have existing code that made this
> > assumption.
> >
> > Thanks again, most appreciated.
> >
>
> No problem. BTW, SQL 2005 has new functions like ROW_NUMBER() that gets rid
> of the need for the self-join ranking method.

• Next in forum: Calling another record into this record
• Prev in forum: how to conver number to string
• Thread view: Re: out of order identity field - sql2000

[Reply to this message]