exists not exsits ??????

-----Original Message-----
From: Rob Haughian [mailto:rob.[Email Address Removed]
Sent: Wednesday, August 27, 2003 1:58 PM
To: LazyDBA.com Discussion
Subject: Query


Does anybody see whats wrong with this query?
The errors are the following:

Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ')'.

update sem_production set val_use = 'D' where exsits
(select * from sem_production P where P.[Date] > '2002_10'
and P.well_id = sem_production.well_id and P.[date] =
sem_production.[date])



Rob Haughian
Saskatchewan Assessment Management Agency (SAMA)
200 - 2201 - 11th Avenue
Regina, SK, S4P 0J8


MS Sql Server LazyDBA home page