wrong in procedure

Question

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[paidamountt]

(

@partyname varchar(max),

@billno varchar(max),

@date varchar(50),

@currentdate varchar(30),

@sectionname varchar(max),

@paymentdate varchar(50),

@paymentamount float,

@paymentcurrentdate varchar(50),

@partydetz varchar(max),

@bdate varchar(30),

@remainamount float,

@billamount float,

@ExpensesName varchar(max)

)

AS

DECLARE @Result int

DECLARE @Resultt int

BEGIN TRANSACTION

IF EXISTS

(

SELECT * FROM expenzsection WHERE sectionname=@sectionname

and partydetz=@partydetz and BillNo=@BillNo and BillAmount=@BillAmount

)

BEGIN

SELECT @Result = -1

END

IF EXISTS

(

SELECT * FROM Amountpaid WHERE partyname= @partyname

and billno=@billno and date=@date and sectionname=@sectionname and paymentamount=@paymentamount and billamount=@billamount

)

BEGIN

SELECT @Resultt = -1

END

ELSE

BEGIN

INSERT INTO expenzsection

(

sectionname,ExpensesName,date,BillNo,BillAmount,

currentdate,partydetz,bdate,remainamount

)

VALUES

(

@sectionname,@ExpensesName,@date,@BillNo,

@BillAmount,@currentdate,@partydetz,@bdate,@remainamount

)

SELECT @Result = @@ERROR

END

BEGIN

INSERT INTO Amountpaid

(

partyname,billno,date,sectionname,billamount,paymentdate,paymentamount,paymentcurrentdate,partydetz,currentdate,bdate,ExpensesName

)

VALUES

(@partyname,@billno,@date,@sectionname,@billamount,@paymentdate,@paymentamount,@paymentcurrentdate,@partydetz,@currentdate,@bdate,@ExpensesName

)

SELECT @Resultt = @@ERROR

END

IF @Result <> 0

BEGIN

ROLLBACK

END

ELSE

BEGIN

COMMIT

END

RETURN @Result

IF @Resultt <> 0

BEGIN

ROLLBACK

END

ELSE

BEGIN

COMMIT

END

RETURN @Resultt

data not inserted in expenzsecction table