How to multiply table coloumn values

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sampathsoft SSC Eights! Points: 855 More actions · Answer 1

OOOPs I Found the solution....

Thanks

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 2

you can find something like this

Create Table #table

(

ITEM varchar(10),QTY int

)

Insert into #table

select 'B0-001', 100 union all

select 'B0-002', 50 union all

select 'B0-003', 25 union all

select 'B0-001', 40 union all

select 'B0-001', 10 union all

select 'B0-005', 50 union all

select 'B0-002', 60

select ITEM,POWER(10.0, SUM(LOG10(QTY)))

From #table

group by ITEM

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 3

sampathsoft (11/28/2010)
OOOPs I Found the solution....
http://mangalpardeshi.blogspot.com/2009/06/multiplying-column-values.html
Thanks

Yep you can also look at this url