Thank you very much for your reply.

I already run dbcc checktable command and i found one of my table currupted. so drop clustered index and recreated it. now its workd...

try this.

select t1.id,(select count(t1a.id)

                from temp1a t1a where 

                 t1.id=t1a.id),

                (select count(t1b.id) from temp1b t1b where 

                  t1.id=t1b.id)

from Temp1 t1

if not then let me know. I have done this many time. so i think i will definately help you out in this issue.

Hi,

first run sp_resetstatus <dbname>

then restart your server and see if it is fine.