Differences between MS SQL and Sybase query results

[krokodajl]

Hi.

I have strange problem with sql query results. I am joining two tables and displaing result with order by clause. But results on MS SQL and Sybase are different. After removing order by clause in both queries results are equal. I am using the same table so I do not know what is the source of this difference.

[sixer]

Maybe they use different collations? Resultset is ordered by the collation you use..

[krokodajl]

I think that collations are not used because order attribute is of type smallint

[sixer]

OK, I guess the orders are different(or joins), which one is the correct one select and which is not?

[krokodajl]

the queries I used in both cases are exactly the same and using the same database.

[sixer]

"After removing order by clause in both queries results are equal. I am using the same table so I do not know what is the source of this difference."
When you add ORDER BY which query sorts the resulset correctly (sybase or ms sql)?

[krokodajl]

ahh. ok :) I have resultset generated from Sybase query. I have rewritten existing code into T-SQL and results I get are not equal so I think that result from Sybase is correct.