SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL

Author

Topic

angela_g
Starting Member

17 Posts

Posted - 2013-09-18 : 09:57:41

Hi Can someone tell me where I am going wrong with this please?

UPDATE RE_EZPAY_AT_AGENCY_DAILY
SET RE_EZPAY_AT_AGENCY_DAILY.STATUS ='H'
SELECT RE_EZPAY_AT_AGENCY_DAILY.STATUS, RE_EZPAY_AT_AGENCY_DAILY.DEBT
FROM RE_EZPAY_AT_AGENCY_DAILY;
WHERE RE_EZPAY_AT_AGENCY_DAILY.DEBT >250
AND RE_EZPAY_AT_AGENCY_DAILY.STATUS ='O';

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2013-09-18 : 10:02:28

[code]UPDATE RE_EZPAY_AT_AGENCY_DAILY
SET STATUS = 'H';

SELECT STATUS,
DEBT
FROM RE_EZPAY_AT_AGENCY_DAILY; --< Remove ; here
WHERE DEBT >250
AND STATUS ='O';[/code]

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources