INSERT INTO [Record] ([TableID], [V004], [V005], [V006])

       SELECT [TableID], 'John', 'Smith', '<john.smith@gmail.com>' FROM [Table] WHERE TableName = 'Staff'

INSERT INTO [Record] ([TableID], [V004], [V005], [V006])

       SELECT [TableID], 'Roger', 'Brown', '<roger_brown@yahoo.com.au>' FROM [Table] WHERE TableName = 'Staff'