Thank to you. Antonio

Yes, my error is raised 'cause I'm inserting a null value in destination table create by 'first phase' of select into statement. But the reason why is visible by checking...

Mark, you're right. Please, clean all hidden chars by an editor and script will work.

hi everybody

Hi everybody.

And finally I found a KB concerning my problem.

As you can read in my older posts the incorrect results seemed related to the maxdop value AND to server...

Hi everybody.

I came to a simplified version of the structure that causes different results (number of rows and values) in my Wind2008 R2 + Sql2008 R2 environment.

I attached a db...

Ok, I'll try. I'll tell you some news (i hope...)

Thank you Ninja's_RGR'us. I noticed that warnings, and the 'query writers' are working.

The server update status is ** SQL Server - Product version: 10.50.1600.1 - Product level: RTM...

Right, they're not table, are both views.

Just an explanation about the group by with all columns. Our developers had used this syntax to verify if views results are the...

Hi Mister Magoo. These are the two QEP (QEP_MaxDop2 is with option MaxDop 2).

Thank you!

I'm not using uncommitted data. Everything is saved on a isolated db for test purpose, as fixed, 'read only' data, and I'm the only reader. On sql 2005 platform (or...

You're right. I'm reducing the logic to send you a more clear sample to reproduce the mismatching results.

Just a note: ok, ordering and where clauses may be the reason why,...

Thank you for answer.

Old Hand, thank you for your suggests. Unfortunately the collations are the same on all instances (we have a strict standard about this). Plus, updating the...

Thank you for answer. I already implemented the explicit granting and revoking 'cause the relationship between schema and user ownership was known, but this solution has some minus. Unfortunately schemas...