;with cte AS 
(
	SELECT
		*,
		ROW_NUMBER() OVER (PARTITION BY CustomerId ORDER BY creationDate) AS RN1,
		ROW_NUMBER() OVER (PARTITION BY CustomerId,CreatedBy ORDER BY creationDate) AS RN2
	FROM
		Tbl
)
SELECT
	*,
	CASE 
		WHEN RN1 > 1 AND RN2 = RN1 THEN 2
		WHEN RN1 > 1 AND RN2 <> RN1 THEN 3
		ELSE 1 
	END AS CodePart
FROM
	cte;

quote:

---

Originally posted by vijay459

hmm are you comparing the three columns i mean for the same customerID then compare CreatedBy if same then check for CreationDate and update '3' for the records that were created at a later date then the first record, if CreatedBy are different then update '2' for the records that created at a later date then the existing record.

---

UPDATE t
SET Code=CASE WHEN DistOwner > 1 THEN 3 ELSE 2 END 
FROM Table t
INNER JOIN (SELECT EmployeeID, MIN(CreationDate) AS MinDate,COUNT(DISTINCT CreatedBy) AS DistOwner
            FROM Table
            GROUP BY EMployeeID
           )t1
ON t1.EmployeeID = t.EmployeeID
AND t1.MinDate <> t.CreationDate