EdwardPeter
asked on
Error: Only one expression can be specified in the select list
Hi,
Please kindly assis in this error message:
Server: Msg 116, Level 16, State 1, Procedure score_add_verify, Line 6
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
create procedure dbo.score_add_verify
@callnumber as int,
@datemonitored as datetime,
@operatorid as int
as
if(select * from operator_analysis
where (callnumber=@callnumber and datemonitored=@datemonitor ed and operatorid=@operatorid))>0
return 1
else
return 0
Go
Please kindly assis in this error message:
Server: Msg 116, Level 16, State 1, Procedure score_add_verify, Line 6
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
create procedure dbo.score_add_verify
@callnumber as int,
@datemonitored as datetime,
@operatorid as int
as
if(select * from operator_analysis
where (callnumber=@callnumber and datemonitored=@datemonitor
return 1
else
return 0
Go
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.