» Transact SQL
» Set based logic (RSS)
Sorry, but there are no more tags available to filter with.
You 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 was originally posted on newsgroups by Tom Cooper.
For example, suppose that you have to ...