UDATE Statement gets subquery error

D

Danny

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UPDATE Statement (Subquery Error) ADP 0
Textbox controlsource = SQL statement ? 2
INSERT INTO gets compile error: Expected end of statement. 3
Can't create recordset to populate userform combobox 3
Subquery can only return one record when used inside the WHERE cla 2
If then statement 3
Update table with values from another table 2
Subquery Sum Containing Parameters 1

Top