Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround? Date: Fri, 01 Jul 2011 23:17:56 +0200 Organization: Erland Sommarskog Lines: 24 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="1979"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+QEFACfp9wQUD3nC6b4tCt" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:3++nSC+H2mmbtecMcQeQ+O0zyo0= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:490 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