[dba-SQLServer] SQL Server 2005 - Aggregate queries in query designer

Francisco Tapia fhtapia at gmail.com
Wed Jan 31 11:42:35 CST 2007


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...



More information about the dba-SQLServer mailing list