UDATE Statement gets subquery error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following SQL statement in an ADP project...

UPDATE dbo.tblRolls
SET QAReviewed = 1, QAReviewedBy = 72
WHERE (JobId = 1001262) AND (QAReviewed = 0)

The statement should update all of the rolls for that particular job that
have not been updated.

I get an error: "Subquery returned more than one value. This is not...."

This has got me stumped and fustrated. I would rather do this in on
statement rather than opening a recordset an looping through each record.

Any ideas?
 
Back
Top