My SP has and select part which will collect all SQL statement that need to execute, but I ca't use UNION ALL because it is not i same table in database, but what I need to be is to do it in one transaction, I can execute every statemement one by one but if third is failed I need to roll back all changes in all tables that was made by SP.

Thanks for answer...