Alexander Kuznetsov : Set based logic Set based
logicenCommunityServer 2.1 SP2 (Build: 61129.1)Set based
calculation of products of several numbers., 17 Mar 2009
22:01:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12714Alexander
Kuznetsov10 can use SUM to calculate the sum of several numbers,
but you cannot directly use set-based logic to calculate a
product. Yet there is a very simple trick – you can use
EXP(SUM(LOG(…))) and get a product of several numbers without a
loop. The trick...(<a href="">read more</a>)<img src=""
width="1" height="1">SQLTransact SQLBrainteasersSet based logic