Hi, Input Name A B C D E F G H output Name Rn A 1 B 2 C 3 D 4 E 5 F 6 G 7 H 8

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

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

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