BEGIN TRANSACTION Create an invoice header record InvoiceKey = GetAutoincValue() Create a set of invoice line records that include the Invoice Key from above. If all ok END TRANSACTION else ROLLBACK endifIs there any problem here if a rollback is done? How does this affect any other users in the system running the same code at the same time?