46985af9   
   From: sorrytoomuchspamalready@xs4all.nl   
      
   I don't think there is a solution that will embarrass you.   
      
   Try this:   
      
     SELECT DocID, Version, VersionID   
     FROM (   
       SELECT DocID, Version, VersionID   
       , ROW_NUMBER() OVER (PARTITION BY DocID ORDER BY Version DESC) AS rn   
       FROM tblDocumentVersion   
     ) T   
     WHERE rn=1   
      
   --   
   Gert-Jan   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)