I get the MS action pack, but not received any copies of SQL2005 yet > -----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] > >
-- 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]
