No sir. its a single instance,single db,single schema.... as default.. no changes..

Yes,

in both case, with nolock and without nolock, problem is still same

Hi Sir,

Thanks a lot for ur reply,

query is used with nolock, but same query if execute from 2 qry windows, its counts r different.

Thanking you,

Virendra