I have a select like this:

SELECT DetailMember.NoMember,DetailMember.NoView
 FROM DetailMember
 GROUP BY DetailMember.NoMember,DetailMember.NoView

This gives 272 records.

For each of those record, I need to insert a record in DetailMember.

The insert is as follow:

INSERT INTO DetailMember (AddUser,AddDate,ModUser,ModDate,NoMember,NoView,Enabled,NoDetail,Order)
 VALUES (1,'2015-04-19 17:17:47.000',1,'2015-04-19 17:17:47.000',PrimaryKeyFromAbove,PrimaryKeyFromAbove,1,7,99)

So, basically, I need to insert 272 records where two fields are from the select.

What would be the proper way to achieve that?