Posted by Andrew Lias on 03/30/06 19:04

> also a temp table with identity is much faster than a running count
> Let me know if it works for you

Thanks. I was trying to avoid using a temp table, but this is a good
solution.

• Next in forum: Re: Row Numbers for a View
• Prev in forum: Bind Variable in CURSOR
• Thread view: Re: Select first n rows of table

[Reply to this message]