table

[nelsonpaixao]

Hi, how can something like this? declare @my_table as table (id int,f_name varchar(50),l_name varchar(50)) insert into @my_table values (select id_user,first_name,last_name from dbo.users) :confused:

nelsonpaixao@yahoo.com.br

[Ashfield]

So whats the question?

Bob Ashfield Consultants Ltd

[TheFM234]

I think you are looking for something like declare @my_table as table (id int,f_name varchar(50),l_name varchar(50)) insert into @my_table (id, f_name, l_name) select id_user, first_name, last_name From dbo.users