This is one way. There are perhaps other ways that utilize the MIN function:;WITH cte AS
(
SELECT GAMt1, GAMt2,
ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Datt) AS RN
FROM
YourTable
)
UPDATE cte SET
GAMt1 = 0,
GAMt2 = 0
WHERE
RN > 1;
________________________________________
-- Yes, I am indeed a fictional character.
How to turn the rest record for zero based on ID
Posted - 11/29/2012 : 18:47:03
