Hi ,
Try like this.....
ALTER PROCEDURE [dbo].[spGetMaxBillingFinancialYearID]
@FinancialYearID INT,
@WardNoID INT,
@MohallaID INT,
@MaxBillingFinancialYearID INT OUTPUT
AS
BEGIN
SELECT @MaxBillingFinancialYearID=MAX(FinancialYearID) FROM PropertyTaxBill WHERE WardNoID=@WardNoID AND MohallaID=@MohallaID AND FinancialYearID < @FinancialYearID
SELECT @MaxBillingFinancialYearID=ISNULL(@MaxBillingFinancialYearID,1)
END
Regards,
GVPrabu