Thanks Sergey.

>Than there only two possibilities left, I think
>
>1. The flaw in your SP logic
>2. The bug in SQL Server.
>
>To exclude the first one ask somebody who knows T-SQL but not familiar with what this SP does to look into it code. To address second one make sure that you have the latest SP installed on SQL server.