Carnation Flowers

Carnation Flowers

  • NA
  • 493
  • 35.5k

wheres error in my code

Mar 19 2017 6:21 AM
Create Proc GetFeesValues
@RateValue decimal(2,18),
@allfees decimal (2,18),
@Mcfees decimal (2,18),
@Docfees decimal (2,18),
@Comfees decimal(2,18),
@MCID int
as
begin
( (select RateValue from dbo.rates where MCID=@MCID)
Set @Appfees=(@allfees*@RateValue)/100
SET @Docfees=(@allfees*@RateValue)/100
Set @Mcfees=(@allfees*@RateValue)/100
insert into dbo.fees(feesapp,feesdoc,feesmc,allfees,McID) values(@Appfees,@Docfees,@Mcfees,@allfees,@MCID))
end

Answers (10)