Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.

Alter Procedure dashbord --1--@userid=1
@userid int
AS
Begin

declare @reportmanager int
declare @admintype int
-- normal employee admintype = 0 , managers admintype > 0
set @reportmanager = (select managerid from reportingperson where employeeid=@userid)
set @admintype = (select  admintype from employee where content_id=@userid)


--select a.content_id ,a.imagetype,b.Fromdate,b.Todate,b.leaveapp,b.leavesubject,b.Reason,b.status,b.createddate from Employee a join leaves b on a.content_id=b.employeeid where a.content_id=@userid
if exists (select 1 where @reportmanager > 0 and @admintype=0)
begin
select b.contentid,x.content_id,x.employeename,x.imagetype,
convert(varchar(10),b.Fromdate,126) as fromdate,convert(varchar(10),b.Todate,126) as Todate,b.leaveapp,b.leavesubject,
b.Reason,(case when (b.status=0) then 'Pending' else 'Approved' end) AS status,convert(varchar(10),b.createddate,126) as Createddate from

  leaves b
left outer join employee x on b.employeeid=x.content_id
where (b.employeeid=@userid --or b.employeeid in (select managerid from reportingperson where employeeid=@userid)
) and b.status=0

select admintype from employee
 where content_id = @userid
 end
 else
 begin
 select b.contentid,x.content_id,x.employeename,x.imagetype,
convert(varchar(10),b.Fromdate,126) as fromdate,convert(varchar(10),b.Todate,126) as Todate,b.leaveapp,b.leavesubject,
b.Reason,(case when (b.status=0) then 'Pending' else 'Approved' end) AS status,convert(varchar(10),b.createddate,126) as Createddate from

  leaves b
left outer join employee x on b.employeeid=x.content_id
where  b.employeeid in (select employeeid from reportingperson where managerid=@userid)  and b.status=0

select admintype from employee
 where content_id = @userid

 end
  End