hi
i've got a piece of code below which works fine, i've since added in lines to try and catch any errors, using begin transaction, rollback etc.
There are 2 bulk inserts which take place, if either one fails I want to rollback completely, i.e. don't truncate the table, don't drop/re-create...