chris123321
IS-IT--Management
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:
I can provide more info depending on what you need.
Thanks.
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:
Code:
INSERT INTO @DealInfo
SELECT ...
FROM ....
WHERE ..
ORDER BY DI.Orderkey
I can provide more info depending on what you need.
Thanks.