Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."
Expand|Select|Wrap|Line Numbers
- create procedure SampleProcedure
- AS
- begin
- Declare @Inc money
- Declare @exp int
- Declare @sal money
- Set @exp = (Select Experience
- From Employee
- Where Experience > 2)
- set @sal= (Select Salary
- From Employee
- Where Experience > 2)
- while @exp > 2
- set @Inc = (@sal*0.2)
- end
- go
pl help me.....