Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | View raw

bill (billmaclean1@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 number? 
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, 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