Have a look at my earlier post about putting the set statements at the beginning of the procedure.

The bizarre solution was courtesy of Microsoft Support