Hello,

I am able to resolve the issue.

select id, boss_id, managername, title, changedate, changetime, ROW_NUMBER() OVER (PARTITION BY id ORDER BY id) rownumber

into #temptable

from @t order by id

select * from #temptable

select * from

(

select A.*,

case when A.managername <> B.managername then 1 else 0 end IsManagerChanged

, case when A.title <> B.title then 1 else 0 end IsTitleChanged

from #temptable A inner join

#temptable B on (A.rownumber = B.rownumber )

AND A.rownumber = 1

where a.id = b.id

UNION ALL

select A.*,

case when A.managername <> B.managername then 1 else 0 end IsManagerChanged

, case when A.title <> B.title then 1 else 0 end IsTitleChanged

from #temptable A inner join

#temptable B on (A.rownumber - 1 = B.rownumber )

where a.id = b.id

) A

order by a.id, a.rownumber

Result will be like:

(Result.JPG has been attached)