Selecting non-Distinct (Duplicate) Records using 2 fields

[LMGroup]

I'm trying to select records from a table where there is no key. I'm using SQL Server 2005. Because of some data entry errors, I need to isolate all the records where they have entered StatusCode 90099 for the same JobN and then I need to change all but the last occurrence of the StatusCode to 90099 for each JobN this occurs in.

This seems to give me the records, but I can't see or change them:

SELECT     JobN, StatusCode, COUNT(StatusCode) AS StatNum
FROM         JobStatus1
WHERE     (StatusCode = 90099)
GROUP BY JobN, StatusCode
HAVING      (COUNT(StatusCode) > 1)
ORDER BY JobN

Thanks for your help!

 

[markros]

Where did you find this button? I am not sure which button do you mean.

PluralSight Learning Library

 

[LMGroup]

It's on the Query Designer toolbar beside the Execute button. I took a screen shot of it, but I don't know where to put it to use the img tag.

 

[markros]

I never use Query Designer. I write queries directly in the New Query window.

PluralSight Learning Library