different results with query and temp var table 1

[chris123321]

When I run a query w/ an Order By clause the results are correct.

However, when I insert that same exact query in a temp var table and SELECT * FROM temp var table the results are not correctly ordered.

The code in its basic form is:

 INSERT INTO @DealInfo
   SELECT ...
   FROM ....
   WHERE ..
   ORDER BY DI.Orderkey

I can provide more info depending on what you need.

Thanks.

 

[SQLDenis]

>>SELECT * FROM temp var table the results are not correctly ordered.


because unless you specify an ORDER BY, order is not guaranteed, not even with an index!

A table is not FILO, use ORDER BY in your select

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[chris123321]

Thanks Denis.

I was able to resolve the issue with your previous reply in the post: thread183-1361784