To elaborate on what RB posted.... You definately can't execute two sql statements
that perform a transaction and one is dependent on the other.

Why cant this be in a batch or two executions?