sql insert a record for each column in another table
INSERT INTO table2([UserID] ,[FirstName] ,[Role]) SELECT [UserID] ,[FirstName] ,[Role] FROM table1 WHERE[Role] = 'Filter'