From: esquel@sommarskog.se   
      
   lk (gofyself@wrong.address.com) writes:   
   > "Erland Sommarskog"  wrote in message   
   > news:Xns9DA38092825DEYazorman@127.0.0.1...   
   >   
   >> Copy and paste both queries in a reply to this post.   
   >>   
   >   
   >   
   > select *   
   > from HumanResources.Shift   
      
   So this was the query that compiled. At least in runs on my machine.   
      
   I think the query with the syntax error is more interesting. Verify   
   that it gives any error before you post.   
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)