Darren DICK
darrend at nimble.com.au
Sun Sep 24 19:27:13 CDT 2006
Howdy Yep they certainly are NOT the same - nor should they be confused as being the same - however in the simple demo I gave it should find his first date in a column on a table (remembering I am an SQL Luddite) Many thanks Have a great day Darren ------------------ T: 0424 696 433 -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Sunday, 24 September 2006 12:19 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Accees Grouping Vs SQL You're right -- the results will often be the same. :) But their functions aren't the same, so, just wanted to warn folks to be careful. Susan H. They are if you use then on the Order By column :-) _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com