Good for selecting random records perhaps. > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 09 September 2004 11:33 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? > > Well, imagine this...ROW_NUMBER is used in dynamic evaluation > of resultsets in T-SQL...think of it like CF MOD paging in > SQL....it allows you amongst other things to bring back a set > (or single) row based on its rank in the current resultset. > > Your example needs to be something like : > > SELECT ROW_NUMBER() OVER(ORDER BY FIELD1) AS rownum, > FIELD1, FIELD2, .[...] > FROM YOURTBLE > ORDER BY FIELD1 > > Basically its gonna be a function you will or will not use, > it all depends on one thing...do you regard your rows in a > table as logical or simply insertions with no logical order? > One > N > > > > > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 09 September 2004 11:15 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? > > How can you use ROW_NUMBER()? > > My first thought was something like this... > > SELECT > *, > ROW_NUMBER() OVER(ORDER BY TestID) AS RowNumber > FROM tblTest > WHERE RowNumber BETWEEN 10 AND 20 > ORDER BY RowNumber > > .. but you can't have the alias in the WHERE clause. Am I > missing the point? > > Ade > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 09 September 2004 10:59 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? > > > 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 > > > -- > 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] > >
-- 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]
