Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.glorb.com!postnews.google.com!v11g2000prn.googlegroups.com!not-for-mail
From: bill <billmaclean1@gmail.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: SSMS Query Designer chokes on ANSI Analytic Functions. Any Workaround?
Date: Thu, 7 Jul 2011 12:05:49 -0700 (PDT)
Organization: http://groups.google.com
Lines: 45
Message-ID: <811c7fc2-1e73-4dfd-8705-2c485644faef@v11g2000prn.googlegroups.com>
References: <fd6bcad5-5c3d-4523-a86b-3910f96b3df4@em7g2000vbb.googlegroups.com> <Xns9F15ED02A6F24Yazorman@127.0.0.1> <a2b4a290-67cb-4a9a-8bb4-429fc44cb2e9@x12g2000yql.googlegroups.com> <Xns9F166AD2268E4Yazorman@127.0.0.1>
NNTP-Posting-Host: 68.228.58.54
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1310065550 22678 127.0.0.1 (7 Jul 2011 19:05:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Jul 2011 19:05:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v11g2000prn.googlegroups.com; posting-host=68.228.58.54; posting-account=71gC0woAAACe89aka1uuzzYro-KCCKcN
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: ARLUEHNKC
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MS-RTC LM 8; InfoPath.3; MS-RTC EA 2; .NET4.0C; .NET4.0E),gzip(gfe)
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:498

I agree that graphics are inherantly limited.  Trying to graphically
build an analytic function would be difficult.  I would just like the
designer not to choke on a query (that may or may not be inside of a
CTE) that is created with valid SQL syntax.

The idea would be this:  Someone comfortable with advanced SQL could
write whatever they need for a query / view.  But  if, say, a column
from an already joined table needs to be added later, a less
experienced person ought to be able to open the query in Designer
without trashing it.

The designer currently represents CTE's (that don't use analytic
functions) as just another box on the painter surface, which is fine.
They need to make it so that designer will recognize the code for
analytic functions and put the resulting column in the appropriate
box.  I don't think that is all that different than SELECT A + B AS C
from <table>

THanks,

Bill

On Jul 2, 1:30=A0am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> bill (billmacle...@gmail.com) writes:
> > Has anyone heard if the Designer will be improved in Denali?
>
> I doubt.
>
> One problem with a thing like the Designer is that there is only so much
> you can do with a graphical interface. How would you visualise a row numb=
er?
> A running sum (improvement to the OVER() clause added in Denali.)
>
> Of course it doesn't help if what you have is rotten from the bottom up.
>
> Personally, I think the best improvement that Microsoft could do is to
> pull it. Alas, it is still there.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@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