• 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