JWColby
jwcolby at colbyconsulting.com
Wed Jan 31 12:00:36 CST 2007
Yes, but in the view designer there is a button that creates the aggregate columns. In the query designer there is not, that I can see. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Wednesday, January 31, 2007 12:43 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL Server 2005 - Aggregate queries in querydesigner Are you referring to SELECT SUM(Field1), Field2, Field3 FROM SomeWickedBigTable Where Field2 = 'SomeText' Group By Field2, Field3 On 1/31/07, JWColby <jwcolby at colbyconsulting.com> wrote: > I am not seeing any way to do aggregate queries from the query > designer. Am I missing something? I can do it from the designer in views. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com