Syntax problems

• Larsi1971

  Ten Centuries

  Points: 1081

  More actions

  February 9, 2004 at 5:09 am

  #107529

  Hello!

  Having problems with a query(SP) here.

  I was trying to check if a value is NULL (Divide by null), but I can't make it work.

  Here is my code;

  declare @UnitWeight as Real

  set @UnitWeight = 1

  SELECT SUM(FVALUE) as fVal from ITEM

  SET @UnitWeight = fVal //Here I get an error saying: "Invalid column Name 'fVal'

   

  Can anyone help me please

  
  -Lars
  
  Please only reply to this newsgroup. All mails would be bounced back.

• nkohad

  SSC Enthusiast

  Points: 109

  More actions

  February 9, 2004 at 5:48 am

  #493229

  Hi Lars,

  Below is the corrected syntax.

  declare @UnitWeight as Real,

  @fVal as Real

  set @UnitWeight = 1

  set @fVal=0

  SELECT @fVal=SUM(isnull(FVALUE,0))  from ITEM

  SET @UnitWeight = @fVal

  Pls check it out.

  Nitin