My result record just return 507 record, i think it maybe small , so i don't know exactly why this result took so long to run when have distinct in...

Well, Thanks very much. You give me a lot of question to answer.

I will follow your suggest and see where i wrong.

Thanks...

Sorry , I can't post table and query because it to long and complex according to business rule which i must explain it if i want you understand what i...

My table already have above 2.000.000 records so, when i create reports use this table it go up 10 minutes to produce report ...

I already known how to use EXEC function to solve my problem. But what i mean is , for example:

declare @a varchar(200)

set @a = 'TableName'

select *...

About dynamic table name , could you tell me how to use varibles which contents table name follow From clause like i said in my previous post.

Regards

Thanks for your advise.

I've already try and seen what you mentioned early.

So , althought, two temporary table have the same name( with differ owner prefix) its name in tempdb...

Well , i think this is the worse security but my app let the clients connect to server which their account which they use to log in computer, i mean...

@To Ronald San Juan:

-"Select system_user" : Thanks , i will try to see what i can do with it Followers