how to Pass arithmetic sign in store procedure value
we have a table with column namely Empname, outstanding
we need to see outstanding value > 0 only through store porcedure
Create procedure spout(@OutstandingType Varchar(100))
As
If @OustandingType=’2’
Set @oustandingType=’>0’
Begin
Select * from table where outstanding=@oustaingType (Means greater than 0)
end
Please help how to do this.