Insertar una fila que sea copia de otra que ya haya

[Carcharhinus]

Esper este ejemplo te ayude de algo

INSERT adult( member_no, street, city, state
,zip, phone_no, expr_date )
SELECT ju.member_no, ad.street, ad.city, ad.state
,ad.zip, ad.phone_no, DATEADD( YY, 1, GETDATE() )
FROM juvenile AS ju
INNER JOIN adult AS ad
ON ju.adult_member_no = ad.member_no
WHERE ( DATEADD(YY, 18, ju.birth_date)