Do you have the ability to change the database schema? I typically add an ordinal value. It just contains the order of the display in an integer field.
Teddy On 12/15/06, Duane <[EMAIL PROTECTED]> wrote: > > Neither. > > I have a form that inserts a record (conference). Each conference can have > up to two hotels which the user can create while on the main form via > popup. > When the user enters the hotel info I store the hotelID on the main form > using JavaScript. > > When the conference record is submitted to the database and the insert > occurs, I then update a crosslink table that joins the two tables > together, > but I want the record to store the order in which they were inserted > because > that determines the display order on the conference page. I need to do > this > in a stored proc as I can not have straight SQL in my code. > > Thanks, > Duane > > > > -----Original Message----- > From: Teddy Payne [mailto:[EMAIL PROTECTED] > Sent: Friday, December 15, 2006 3:07 PM > To: SQL > Subject: Re: row index > > Are you performing bulk inserts or looping over inserts? > > Teddy > > On 12/15/06, Duane <[EMAIL PROTECTED]> wrote: > > > > Within a table > > > > Something like: > > > > Select x, y, currentrow > > From table > > Where z = @a > > > > > > I'm doing an insert into a table and I would like to track the order in > > which the data is inserted. Like so: > > > > Insert dbo.table (a, b, displayOrder) > > Select x, y, currentRow > > From table2 > > Where table2.id = c > > > > > > > > > > -----Original Message----- > > From: Robertson-Ravo, Neil (RX) > > [mailto:[EMAIL PROTECTED] > > Sent: Friday, December 15, 2006 2:41 PM > > To: SQL > > Subject: Re: row index > > > > Row within a resultset (ColdFusion) or a row within a table? > > > > > > -----Original Message----- > > From: Duane > > To: SQL > > Sent: Fri Dec 15 18:47:40 2006 > > Subject: row index > > > > Is there a way within SQL to get the current row index from a query? > > > > Thanks, > > Duane > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2669 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
