I Want To Update All The Rows After The First Row For Each Team
I want to update all the rows after the first row for each Team. TableName: Test ID , Team , StartTime, EndTime, TotalTime 1....... A.........18:00.........20:00..........2:00 2...
Solution 1:
You can use CTE for this.
with cte as
(
select test.*, row_number() over (partition by team order by ID) as teamRowNum
from TEST
)
UPDATE cte SET StartDate = DateAdd(SECOND, - ProjectedTime * 60, EndDate)
where teamRowNum > 1
Solution 2:
You can use a CTE with row_number()
:
with toupdate as (
select t.*, row_number() over (partition by team order by id) as seqnum
from test
)
update toupdate
set StartDate = DateAdd(SECOND, - ProjectedTime * 60, EndDate)
where seqnum > 1;
Post a Comment for "I Want To Update All The Rows After The First Row For Each Team"