how to use the if-else condition in storedprocedure

Question

My Requirement is:

I need to check  

 

1.if Empid is Null or not?

      If it is Null I need to display the message  

2, if Empid exist or not in the table

         if Empid exists I need to display the record 

3. If FinancialYear is is Null or not?

4. if financial year exist or not in the table

5. Based on the Empid I need to get the FinancialYear

6.After getting the financial year If the financial year is existed or not in the table

 

Below u can find the code

 

pLease help me this 

 

ALTER PROCEDURE [dbo].[SPBudget]

@empID varchar(50),

@financialYear varchar(50),

@cost varchar(50)

AS

BEGIN

Declare @records varchar(max)

Declare @Financial varchar(max)

Declare @Cost varchar(max)

IF ISNULL(@empId,0)!=0

BEGIN

if(select Count([Num]) from [Employee] where [Num]=@empId)<=0

set @records='empid doesnot exist'

select @records as [EmpID]

END

IF ISNULL(@financialYear,0)!=0

BEGIN

if(select Count( [FinancialYear]) from [Expense] where [FinancialYear]=@financialYear)<=0

set @Financial='Year doesnot exist'

select @Financial as [FinancialYear]

END

IF(@cost!=0)

BEGIN

if(select Count( [Cost]) from [Employee] where [Cost]=(select [Cost] from [Employee] where [Num]=@empId))<=0

if(@cost=@empId)

begin

select * from [Employee]

END

Else

begin

set @Cost ='cost doesnot exist'

end

END

END