Wht is error in this proc.

• Sandeep Mahajan-393729

  SSC Eights!

  Points: 858

  More actions

  April 9, 2007 at 2:02 am

  #370130

  Create Procedure SPPS

  @Year1 int, @Year2 int ,@Year3 int ,@Year4 int ,@Subject1 int ,@Subject2 int, @Subject3 int, @Subject4 int

  AS

  BEGIN

   declare @Money int

   if exists (select Year, Subject from BarPieChart12 where Year=@Year1)

   (

    @Money = SELECT Subject from BarPieChart12 where Year=@Year1

    @Subject1 = @Money + @Subject1

    update BarPieChart12 set Subject1=@Subject1 where Year=@Year1

  &nbsp

   else

    INSERT INTO BarPieChart12 (Year,Subject) VALUES(@Year1,@Subject1);

  Plz it's URGENT

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  April 9, 2007 at 2:20 am

  #699273

  Create

  Procedure SPPS

  @Year1

  int, @Year2 int ,@Year3 int ,@Year4 int ,@Subject1 int ,@Subject2 int, @Subject3 int, @Subject4 int

  AS

  BEGIN

  declare @Money int;

  if exists (select Year, Subject from BarPieChart12 where Year=@Year1)

  BEGIN

  SET @Money = (SELECT Subject from BarPieChart12 where Year=@Year1);

  SET @Subject1 = @Money + @Subject1;

  update BarPieChart12 set Subject1=@Subject1 where Year=@Year1;

  END;

  ELSE

  BEGIN

  INSERT INTO BarPieChart12 (Year,Subject) VALUES(@Year1,@Subject1);

  END;

  END

  ;

• Sandeep Mahajan-393729

  SSC Eights!

  Points: 858

  More actions

  April 10, 2007 at 12:41 am

  #699450

  I m very happy.

  Thanx