here i am doing like dis

declare @tbl1 table (TBLID int identity(1,1),ID int,patientName varchar(10),age int,city varchar(100),Mobile int)

insert @tbl1(ID,patientName,age,city,Mobile) select 1,'Ramesh',20,'HYD',12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,87654321

select * into #temp from @tbl1

select name into #Result from tempdb..syscolumns where id=OBJECT_ID('tempdb..#temp')

alter table #Result add oldvalue varchar(100), newvalue varchar(100)

declare @old varchar(max),@New varchar(max),@column varchar(100)='name'

declare @tbl table (Value varchar(max))

declare temp cursor local for

select name from #Result

open temp

fetch next from temp into @column

while @@FETCH_STATUS=0

begin

insert @tbl exec ('select '+@column+' from #temp ')

select top 1 @old= Value from @tbl order by Value desc

select top 1 @New= Value from @tbl order by Value asc

update #Result set oldvalue=@old,newvalue=@New where name=@column

delete from @tbl

fetch next from temp into @column

end

select * from #Result where oldvalue<>newvalue

drop table #temp ,#Result

can any help me

is there any best way