ahhhh..alter...perfect....thanks

Awesome!

thanks Leo and please say thank you to everyone that helped...

good karma to you...

intersting Leo....

can you elaborate?

Thanks everyone..

Yeah I kinda figured

thanks man

No, you don't have to setup a role.

from my dev:

So, the query in question does scan because of the table size over 500K records?

PayeeMaster table has about 53585 records in dev vs. 555077 in PaymentChild

Compare

SELECT Count('x')

FROM...

understood thanks again

ahhh...so if it has to go the row specified in the where..then it's able to count along the way?

whereas if there is no where clause it has to...

my dev just emailed me back and said that if I look at this query it uses 'SEEK' not scan and he;s right!!

what the hell?

SELECT Count('x') FROM PayeeMaster PM

INNER JOIN...

yeah I know...I've talked to the devs about no lock...

they stopped using it, and I remove it where/when I see it...

okay thanks everyone

good karma to you all thanks for taking the time top answer..

I'm having trouble with the syntax when I try to add this to my query:

SELECT Count('x') FROM PayeeMaster PM

INNER JOIN PayeeLink PL ON...

anway to get the count in the above query without using 'count'?

thank you