i'm working on a process where I will import data into a temp table, and then want to validate some of the data before proceding 'live' with it to apply updates.
I'd like to be able to write bad rows to separate table, with up to 2 error messages. The remaining (good) rows would be in a...