Pages

Sunday, April 29, 2012

Calculate product of given numbers in SQL server



The below example shows how to find the product of values in one column of table

declare @values table (value float)
declare @product float


insert into @values values (1)
insert into @values values (-3)
insert into @values values (2)
insert into @values values (6)


set @product = 0


select @product = exp(sum(log(abs(value)))) from @values


if ((select count (1) from @values where value < 0) % 2) =1
begin
  select @product = @product * (-1)
end


select @product


No comments:

Post a Comment