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]
