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