I have loved it so far...come a long way from Alpha....to be honest is the T-SQL additions / modifications which are proving to be fantastic.....
ROW_NUMBER is one of those holy grail (and nemesis) of RDBMS...some people require it etc and some people think its stupid.....jeez Oracle has had these abilities for while now. The biggest addition has to be Reporting Services (now available for 2K also) and the integration of the CLR...which is huge for us. N -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 09:55 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? But come oooooon, dynamic TOP(n), how cool is that!?! :OD How are you finding it so far? I'm not too impressed with the management studio so far, seems awfully slow on my machine. Have you found many uses for the new windowing/ranking functions? Maybe I'm missing the point, but how can I make use of ROW_NUMBER() and filter on it? Anyone else started to play with SS 2005 yet? Ade -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 09:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] A new problem ??? Yep, it also has a shed load more ;-) which is even jucier... -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 17:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] A new problem ??? Or since it's inline SQL, CreateUUID might work for any other DB. <cfquery...> SELECT TOP 5 * FROM table ORDER BY 'CreatUUID()' </cfquery> Give it a try, it might work. Ade BTW, I have installed SQL Server 2005 Beta 2, got a bunch of new features. Now call me an idiot, but my favourite is dynamic TOP(n)! -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
