Hi

CDC can can work as well as trigger. If you want to create like a manual system I recommend using something like this

Create a Change table in your database lets...

Hi

So i am assuming that your new table contains the id and the max time of the corresponding id in the original table.

The problem with the while loop that...

Hi

Please find the needed Pivot query below

Create Table #tblPersonTask

(

DayNmchar(3),

Personvarchar(20),

Tasksmallint

)

insert into #tblPersonTask

select 'sun', 'Jhon', 1 union all

select 'sun', 'Smith', 1 union all

select 'sun', 'Dan', 2 union all

select 'mon', 'Smith', 2...