different results query analizer vs. enterprise manager

hi,
i have a query which i run in query analyzer.
if i copy it to the enterprise manager it rearranges
my query. this is not a problem for me, but the result is
different, there are different numbers of rows given back.
is that a known bug, or are there some things i can do
to change that behaviour? with this i do still not know
which result is right...
greetings,
mike
Do you have a query to post which might help us a bit more?
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
<peppi911@.hotmail.com> wrote in message
news:1135957879.649605.82940@.z14g2000cwz.googlegro ups.com...
> hi,
> i have a query which i run in query analyzer.
> if i copy it to the enterprise manager it rearranges
> my query. this is not a problem for me, but the result is
> different, there are different numbers of rows given back.
> is that a known bug, or are there some things i can do
> to change that behaviour? with this i do still not know
> which result is right...
> greetings,
> mike
>
|||(peppi911@.hotmail.com) writes:
> i have a query which i run in query analyzer.
> if i copy it to the enterprise manager it rearranges
> my query. this is not a problem for me, but the result is
> different, there are different numbers of rows given back.
> is that a known bug, or are there some things i can do
> to change that behaviour? with this i do still not know
> which result is right...
I assume that you mean the View/Query Designer in Enterprise Mangager?
Yes, this is known to rearrange queries, and sometimes in a fashion
that alters the result. The tool can be nice for demos, and simple
queries, but you outgrow it pretty quick, as it is not very capable
with complex queries.
And, no, it has not been improved in SQL 2005. It still can mangle
your queries. But to make matters worse, it is now more exposed.
Generally, I would recommend you to stay away from that tool. Run
your queries from Query Analyzer, or the Query Editor in Mgmt Studio.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx