All pastes #165359 Raw Edit

Demian

public sql v1 · immutable
·published 2006-09-09 20:22 UTC
rendered paste body
-- I want to do this:foreach (row in oldTable){  insert into Aspect values (row.Name)  insert into AspectDetail values (Scope_Identity (), Description, Modification)}Aspect------Id (int) PKName (varchar)Creation (date)AspectDetail------------AspectId (int) FKModification (date)Description (varchar)OldTable--------Id (int) PKName (varchar)Description (date)LastChange (date)