ed0bf66e   
   From: esquel@sommarskog.se   
      
   bill (billmaclean1@gmail.com) writes:   
   > SUMMARY:   
   > SSMS Query Designer chokes on analytic functions.  Is there any   
   > workaround for this?   
      
   Yes, don't use the Query Designer. It's a piece of crap. For reasons   
   you just have discovered. There are plenty of constructs it does not   
   support. It tends to put in TOP(100) PERCENT ORDER BY in view definitions   
   which is useless. It also has quite funky formatting of the queries.   
      
   Yes, it may seem comfortable for the novice, but that is just like   
   the bikes we had when we were kids. They had three wheels, or if they   
   were two-wheeled, they had two small support wheels. But there was a   
   point when mom and dad took those away, and told us that it was time   
   that we learn to master the bicycle as it is meant to be used.   
      
      
   --   
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)