Hi Guys!

@paul-2: Thanks for test data! 🙂

I always prefer the joined UPDATE:

UPDATE e SET

e.memostatus = CASE WHEN m.employee_id IS NULL THEN 'N' ELSE 'Y' END

FROM @Employee e

LEFT JOIN @MemoDetail m ON e.employee_id = m.employee_id

If there are many duplicates in memo-details table, I'd use a CTE:

; WITH m (employee_id) AS

(

SELECT DISTINCT

employee_id

FROM @MemoDetail

)

UPDATE e SET

e.memostatus = CASE WHEN m.employee_id IS NULL THEN 'N' ELSE 'Y' END

FROM @Employee e

LEFT JOIN m ON e.employee_id = m.employee_id

Greets

Flo