Inserting in a table can cause data movement and selecting from the same table in the same statement ...
social.msdn.microsoft.com