Does anyone know how to increase a value for each returned row in an sql-statement without using cursors? like:
declare @counter as int
set @counter=0
select *,@counter++ from item