Update First Instance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 06/30/04 

Date: Wed, 30 Jun 2004 04:10:23 -0700

Hi All

I have data in a tables that looks as per below:

QID Res
--- ---
123 Y
123 Y
456 Y
456 Y
789 Y
789 Y
789 Y
000 Y

How do I update the table so that the first instance of
QID is set to N and all the remaining values are left as Y

ie.

QID Res
--- ---
123 N
123 Y
456 N
456 Y
789 N
789 Y
789 Y
000 N

Thanks