Sort Order - Can it be preserved in this situation.

[dubian]

Question.

Is there a way I can get the order preserved (possibly with a SQL
config option or such) using the folowing;

Select ..... into #temptable where ... Order By ...

then

Select * from #temptable

and have the order preserved in accordance with the select statements
Order By clause used to build the temptable.


...
using ADO.NET 1.1 with the MS_SQL Client - ExecuteReader() method.

I am porting an application that used SQL 6.5 in this manor and it
seememd to preserve the order using this pattern, however, Sql2000 does
not.

Thanks.

 

[Guest]

dubian,

A relational database never guarantees row order.

Kerry Moorman