» Set based logic
» Transact SQL
» Brainteasers (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 ...