Re: Error using UPDATE statement

From: solidsna2@xxxxxxxxx
Date: 28 Feb 2006 07:22:35 -0800

Well I figure out the problem. I had a GROUP BY at the end of the
SELECT subquery.

UPDATE Tbl1
SET Row2 = '1'
WHERE Tbl1.Row1 = (SELECT Tbl2.Row1
FROM Tbl2
WHERE Tbl2.Row1 = Tbl1.Row1
AND CURRENT_TIMESTAMP >= Tbl2.Row3 GROUP BY
Tbl2.Row1)

Thank you again for your help.

.

References:
- Error using UPDATE statement
  - From: solidsna2
- Re: Error using UPDATE statement
  - From: Erland Sommarskog
- Re: Error using UPDATE statement
  - From: solidsna2

Prev by Date: Create New Table advice
Next by Date: How to avoid cursors
Previous by thread: Re: Error using UPDATE statement
Next by thread: Installer differences - SQL2K under W2K versys W2K3
Index(es):
- Date
- Thread

Relevant Pages

Re: Get the latest status
... Use a subquery. ... Tips for Access users - http://allenbrowne.com/tips.html ... tbl1: id, start_dt, end_dt ... tbl2, id, status, status_change_dt ...
(microsoft.public.access.queries)
Re: Using Cursors
... > UPDATE tbl1 ... > FROM tbl2 ... > Tibor Karaszi, SQL Server MVP ... >> I have a question about how to replace a cursor with a set based operation. ...
(microsoft.public.sqlserver.programming)