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.
Expand|Select|Wrap|Line Numbers
- update immunizations
- set recall_dosedate =
- (select cast(cast(year(i.recall_dosedate) as varchar) + '-' +
- cast(month(e.dateofhire) as varchar) + '-' +
- cast(day(e.dateofhire) as varchar) as datetime)
- from immunizations i, employee e
- where i.employeeno = e.employeeno
- and i.recall_dosedate = '2008-01-02 00:00:00.000'
- and i.recall_immcode = 'TBSymSurAn')
- where recall_dosedate = '2008-01-02 00:00:00.000'
- and recall_immcode = 'TBSymSurAn'