Really nice question!
Missed that we did not have a batch terminator after "BEGIN TRAN" and that we were dealing with nested transactions here.
Enjoyed the question thoroughly. Thank-you very much!
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins