Home Forums SQL Server 7,2000 T-SQL Syntax problems RE: Syntax problems
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