This was only one of the possible solutions... I wanted to get over the fact that there should not be duplicates in a table and that he should explore the...

Any object means :

Unique constraint

Primary key

table

trigger

user defined function

defaults

check constraints

Fk

views

extended procs --for master only

replication functions

Indexes can have the same name as the table or any other objects.

Did I forget anything?

I don't care about the query, I care about the results .

Maybe you should ask Steve to generate a top 100 lists of the most prolific posts day/user. That would clear it up

Only something??????????????????????

I think you need to reread this thread .

Select O.name from dbo.SysObjects O inner join dbo.SysComments C on O.id = C.id where C.Encrypted = 1 and O.XType = 'V'

You can always detach the databases, move 'em to E and reattach... just one of many ways. But of course the database is not available while you do this.

And to -1 if it's tinyint, smallint, int or bigint (god forbid).

"(NO MORE GUESSING!)"

Heard that one before .

Anyways we'll have to see what he has to say about it.

Maybe that's the case, but what if he fetchs only a range of rows instead of all rows... wouldn't it all come back to the same thing in the end?

I implied that in my answers on other threads .

Sounds like you're finally agreeing with me .

Have you ran a trace to see what calls are made on the server with each version of the code. Maybe there are also settings that you misseds.

Case when RC = 'Y' THEN 'RC, ' ELSE '' END +

Case when P1 = 'Y' THEN 'P1, ' ELSE '' END +

Case when ME...

A few things :

1 - Why do you have duplicates in that table?

2 - If this is not a requirement, then why do you complicate your life?

3 - Are...