tag:blogger.com,1999:blog-5849265.post114915895326772600..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: Finding the product of a column ...Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5849265.post-23560710115726591752007-12-18T16:42:00.000+05:302007-12-18T16:42:00.000+05:30Some other methodshttp://sqlblogcasts.com/blogs/ma...Some other methods<BR/>http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/13/simple-multiply-function.aspxUnknownhttps://www.blogger.com/profile/13241916831072779717noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1149573951159178942006-06-06T11:35:00.000+05:302006-06-06T11:35:00.000+05:301. Yes true varalakshmi it fails for some numbers ...1. Yes true varalakshmi it fails for some numbers :)<BR/><BR/>2. Regarding "why we can't use Price * Tax directly" ---- Yeah that's how we normally do it. I was just trying to simulate "multiplication" using the built-in Sum(), Power() and Log10() functions. [Hope now you would understand how free i am at home :) ]<BR/><BR/>To my knowledge no where in a real world scenario we would be using this Vadivelhttps://www.blogger.com/profile/13387133927257826888noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1149568440429478472006-06-06T10:04:00.000+05:302006-06-06T10:04:00.000+05:30I tried implementing the same for finding the prod...I tried implementing the same for finding the product using the workaround you have specified. But It works fine only with few set of datas.<BR/><BR/>For example,<BR/><BR/>Select Power(10, Sum(Log10(price))) + 1 from TblTransaction<BR/><BR/>holds good for number pairs such as (55,10),(10,5) etc., whereas it<BR/>fails for (25,2)etc.,<BR/><BR/>The another example to find the product of two Anonymousnoreply@blogger.com