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:2667 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
