Generate sequence with out row

Ramesh Palanivel8y ago

Accepted answer

Hi Sai,

Are you tried this links,

https://www.c-sharpcorner.com/blogs/displaying-row-number-without-using-rownumber-function-in-sql-server1

https://stackoverflow.com/questions/18851527/how-do-i-generate-row-number-without-using-rownum-in-sql-server

Nitin Sontakke8y ago

You might not be expecting this as an answer, but it is technically correct one.

declare @name table
(
[name] varchar(10) not null
)
insert into @name values
('A')
,('B')
,('C')
,('D')
,('E')
,('F')
,('G')
,('H')
select [name], ascii([name]) - 64 [rn]
from @name

Sai Reddy8y ago

Hi Ramesh,

I need the row numbers with out using Row_number() function.

Ramesh Palanivel8y ago

Hi Sai,

What is the query you have written and what will be your exact output. Please give more information about your requirement. It will help us to provide solution easily.

Thanks

Generate sequence with out row_number() function.

4 Replies