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