Hi Nagasubba,
You can use dynamic SQL .
Example :-
For Example i have taken only 3,4 column..
Create Table #MyTable (Number varchar(max),Accountname varchar(max) ,LOB varchar(max) )
INSert into #MyTable
Values ( 'one','vijay dinanath','Developemnt'),
( 'Two','Mangal','Developemnt'),
( 'Three','Amrendra','Developemnt')
DECLARE @order Nvarchar(50)
set @order='Accountname asc';
Set @Query='
;WITH Result as (
SELECT ROW_NUMBER()
OVER (ORDER BY '+@order+') AS Row,
Number,
Accountname,
LOB
FROM #MyTable WITH (NOLOCK)
)
select * from Result where Row Between 1 AND 10'
Exec (@Query);