Re: Insert cursors?

From: Chris Brauer <funky@funkytown.de> > > > have been successfully shipped and inserted? > > > > Yes, but you have to be able to recreate the row that failed, and > > fix the problem, and then recreate all the rows after the one that > > failed and resubmit the whole lot before continuing. > > > > This tends to be rather tricky to do! > >What about using validation tables and filtered triggers in this case ? >You could check for errors AFTER loading all the data without having many >problems WHILE the main action. > >But... when I see which famous guys answered this posting already >I think that's maybe too easy ? :-) Even famous guys can miss the obvious... ;) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com