>1) the code I want to write is itself part of a large transaction. If have a smaller BEGIN/END TRANS in the code you sent, will that 'mess up' my larger transaction? [I wouldn't think it would, but figured I'd ask]

You would only run into issues if you did a rollback on one of nested transactions. It will cause a rollback on all of them.

-Mike

>Interesting! I have 2 questions...
>
>1) the code I want to write is itself part of a large transaction. If have a smaller BEGIN/END TRANS in the code you sent, will that 'mess up' my larger transaction? [I wouldn't think it would, but figured I'd ask]
>
>2) if two different users happen to do something in the application such that this code executes at exactly the same time, would it bomb? [since the name of the global temp name is the same]
>
>Thanks,
>Kevin