Also, in my another piece of code, I need to use

table variable and dynamic sql.

I need to handle a dynamic search, the input search criteria will be any or...

It works for me. Thank you very much.

Yes, I am able to do insert into @mv_table

select count(*) from @mv_table

no problem.

The issue is:

If I need to create the sql dynamically, like this:

set @mv_sql = 'select count(*) from...

Thanks for the reply. The two columns' values normally are not the same. I think the easiest way to do is to let the two columns share one identity....

I have no problem to declare a table variable inside my procedure. But if I want my procedure to return a table variable, then, I always get the compiling error:

Server:...

If no way to get rid of the databaseownername

when call a function, then I guess I have to change my function call to a procedure call. But

my function returns...