Why not make a simple native SP looping over (multi row) INSERTs? Code will be readable and modifiable by normal people unlike recursive SQL, and you could even add some commit logic to make the DBA (you?!) happy.
Rocket Software77 Fourth Avenue • Waltham, MA • 02451 • USAE: email@example.com • W: www.rocketsoftware.com
Views are personal.
Point taken! And of course I did not intend to insult the "not normal" people on the list ;)
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504