Cool.. I havent used MSSQL (as I said earlier). My company used Oracle 9i currently and are in the process of upgrading to 10g. To each his own, aye?
On Sun, May 4, 2008 at 4:38 PM, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > ** Private ** wrote: > > One of the features I absoluetly love about Oracle is the over() function.. > > If you have a recordset and are trying to get multiple sums of columns > > grouped by different columns.. > > in MSSQL you'd have to create multiple queries right? > > MS SQL Server has the standard SQL Window functions. > > Jochem > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:259757 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
