Hi,

I'm trying to update a column in a table like this.

UPDATE TurnTimeTable
SET TurnTime = (SELECT (DATECOMPLETE - DATESTART) as 'Turn Time'
WHERE EmployeeID NOT LIKE '5%' AND EmployeeID NOT LIKE '9%'
)


Is there a way to do this without getting this error..

Server: Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. 
This is not permitted when the subquery follows =, 
!=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.