From: anton.txt@g{oogle}mail.com   
      
   I wrote:   
      
   > SELECT   
   >    #LOG.m_used               AS  Used       ,   
   >    #LOG.m_max                AS [Max]       ,   
   >    #LOG.m_used - #LOG.m_max  AS [Overrun]   ,   
   >    PREV.m_used - #LOG.m_used AS [Delta Used],   
   >    PREV.m_max  - #LOG.m_max  AS [Delta Max]   
   > FROM      #LOG   
   > LEFT JOIN #LOG PREV ON PREV.N = #LOG.N - 1   
      
   I forgot to ORDER BY #LOG.N , because the results were   
   already ordered that way, but I understand it is merely a   
   coincidence, albeit a likely one :-)   
      
   --   
   ()  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)