Select into a temp table that has an idenity column and then select the result from that.
Justin > -----Original Message----- > From: Matthew Small [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 4:54 PM > To: CF-Talk > Subject: OT: (cross post) SQL row numbering > > > How can I get SQL server to automatically number my rows of a > recordset, > as I retrieve it? > > If I have the following information in a table (example data) > > Name Age > Joe 20 > Sally 14 > Jim 15 > > And I do a query: > > Select somefunction() as rownum, name, age from table > > I want a recordset of > Rownum Name Age > 1 Joe 20 > 2 Sally 14 > 3 Jim 15 > > Since this is going to be a small part of a larger stored procedure, I > can't use CF. > > > Thanks > > Matthew Small > IT Supervisor > Showstopper National Dance Competitions > 3660 Old Kings Hwy > Murrells Inlet, SC 29576 > 843-357-1847 > http://www.showstopperonline.com > > -----Original Message----- > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 4:42 PM > To: CF-Talk > Subject: RE: MM Pricing Problem on CFMX for J2EE > > I would agree that it is an over-generalized statement, however, the > technical support DOES have its issues. > > I've had a problem with JVM Memory Settings in CFMX Pro but > in order to > speak to someone in your tech support dept. I have to pay at > least $250. > It seems that when you pay over $1000 for software that you should get > at least SOME technical support - even for a limited time. I bought an > iBook and got 90 days unlimited support. My iBook cost about > the same as > CFMX Pro. > > It would be nice to get some temporary support for our money. > After all, > isn't that one of the arguments about why people choose > retail products > over open-source? Technical Support. You're supposed to get > more if you > pay right? I can write PHP and pay someone to give me support on that, > but since I paid $1000 for CFMX I expected some free support - or at > least someone courteous on the phone. > > I'm not leaning towards MM bashing mind you - I love CFMX and MM > products in general, but seriously, do something about your support > options. > > Even email or chat-based support to determine if higher-level paid > support is in order. Sort of a Tech Support Triage or something. > > That's just my opinion ... > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net > [EMAIL PROTECTED] > (704) 569-9044 ext. 254 > > ************************************************************** > ********** > ************* > Any views expressed in this message are those of the > individual sender, > except where the sender states them to be the views of > Garrison Enterprises Inc. > > This e-mail is intended only for the individual or entity to > which it is > addressed and contains information that is private and > confidential. If > you are not the intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to > [EMAIL PROTECTED] > ************************************************************** > ********** > ************* > > > -----Original Message----- > From: Mike Chambers [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 4:28 PM > To: CF-Talk > Subject: RE: MM Pricing Problem on CFMX for J2EE > > > > -----Original Message----- > > From: samcfug [mailto:[EMAIL PROTECTED]] > > > advantage. And of course everyone knows that their tech > > support sucks big time. > > That is quite a generalization, and one i personally feel is > incorrect. > While some people may have had poor experiences with tech > support (such > as yourself), to state that "everyone" feels the way you do is, in my > opinion a rather large leap. > > mike chambers > > [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
