Well then, I stand corrected. I had a strong feeling that I had tried
and failed when referring to aggregate expressions by alias in the order
by clause in the past (on SQL Server 2000, at least). Must have it
confused with a different problem. Thanks for verifying it does work.
Carl
On 12/19/2010 12:32 PM, Adam Cameron wrote:
And Microsoft SQL Server 2000 - 8.00.760 (this is a bare-bones MSDE
install).
So this bears out both the docs and my recollection.
On Dec 18, 2:46 pm, Adam Cameron<[email protected]> wrote:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
On Dec 17, 3:42 pm, Carl Von Stetten<[email protected]> wrote:
What version of SQL Server are you using?
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
