Re: instead of SELECT TOP: cursors or nested queries?

> 10K records is hardly large and nothing beats testing which is exactly
> what you should do. It couldn't take more than 5 minutes to build a
> table with 50,000 rows and find out.
>
> But my gut would be the in-line view will almost always outperform the
> cursor.

I did as you said and you are right: using the nested selects are very faster than a cursor.

Thanks all. Received on Tue Jan 13 2004 - 12:33:42 CST