There is no direct way to multiply all the values of a column as we do summation using SUM(col). But it is possible with the following methods create table test (i int, amount float) insert into test(i,amount) select abs(cast(cast(newid() as varbinary(100))