INSERT INTO DetailMember (AddUser,AddDate,ModUser,ModDate,NoMember,NoView,[Enabled],NoDetail,[Order]) SELECT 1,'2015-04-19 17:17:47.000',1,'2015-04-19 17:17:47.000',DetailMember.NoMember,DetailMember.NoView,1,7,99 FROM DetailMember GROUP BY DetailMember.NoMember,DetailMember.NoView