Groups > comp.databases.ms-sqlserver > #490

Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround?

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround?
Date	2011-07-01 23:17 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F15ED02A6F24Yazorman@127.0.0.1> (permalink)
References	<fd6bcad5-5c3d-4523-a86b-3910f96b3df4@em7g2000vbb.googlegroups.com>

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SSMS Query Designer chokes on ANSI Analytic Functions.  Any Workaround? bill <billmaclean1@gmail.com> - 2011-07-01 11:17 -0700
  Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? Erland Sommarskog <esquel@sommarskog.se> - 2011-07-01 23:17 +0200
    Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? bill <billmaclean1@gmail.com> - 2011-07-02 01:05 -0700
      Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? Erland Sommarskog <esquel@sommarskog.se> - 2011-07-02 10:30 +0200
        Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? bill <billmaclean1@gmail.com> - 2011-07-07 12:05 -0700
    Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? "Fred." <ghrno-google@yahoo.com> - 2011-07-04 16:31 -0700

csiph-web