From: anton.txt@g{oogle}mail.com   
      
   I wrote to Erland Sommarskog:   
      
   > > The  SELECT  wants  a page lock but is blocked by the IX   
   > > lock held by the UPDATE statement. You  need  to  add  a   
   > > ROWLOCK hint to that query.   
   >   
   > That  solved  it,  thanks.  Somehow it did not occur to me   
   > that I needed a (ROWLOCK) for the SELECT  as  well.   
      
   A simplified version of my query:   
      
      SELECT A.Code   
      FROM      [@GTTABLEKEYS] A WITH (NOLOCK)   
      LEFT JOIN [@GTTABLEKEYS] F WITH (READPAST,ROWLOCK) ON F.Code = A.Code   
      WHERE F.Code IS NULL   
      
   --   
   ()  ascii ribbon campaign - against html e-mail   
   /\  http://preview.tinyurl.com/qcy6mjc [archived]   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)