-- I want to do this:

foreach (row in oldTable)
{
  insert into Aspect values (row.Name)
  insert into AspectDetail values (Scope_Identity (), row.Description, row.Modification)
}

Aspect
------
Id (int) PK
Name (varchar)
Creation (date)


AspectDetail
------------
AspectId (int) FK
Modification (date)
Description (varchar)


OldTable
--------
Id (int) PK
Name (varchar)
Description (date)
LastChange (date)