declare @table table (id int, [name] varchar(10), gender char(1))

declare @MaleNames table (id int identity(1,1), [name] varchar(10))

insert into @table values (1,'John','M')

insert into @table values (2,'Sue','F')

insert into @table values (3,'Jane','F')

insert into @table values (4,'Mark','M')

insert into @table values (5,'Bill','M')

insert into @MaleNames SELECT [name] from @table where gender = 'M'

SELECT * FROM @MaleNames