Re: Row Order

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 13:23:20 -0500

> Order inside the table is not guaranteed. However, order in the result
set
> of a query can be - with an ORDER BY. Why is it that you "need for the
rows
> to exist in the temp table in the order specified by the ORDER BY clause"?

My guess is that a cursor then operates against the #temp table, and
somebody doesn't want to have to add an ORDER BY clause to the cursor
definition. :-)