Thinking outside the box

Patron Saint of Lost Yaks

posts - 202, comments - 734, trackbacks - 4

My Links

News

Post Categories

<< Reading the transaction log | Home | Bin packaging >>

How to get the productsum from a table

IF EXISTS(SELECT * FROM YourTable WHERE Number = 0)
    SELECT 0.0E
ELSE
    SELECT CASE IsNegativeProduct
               WHEN 1 THEN -EXP(theSum)
               ELSE EXP(theSum)
           END
    FROM   (
               SELECT SUM(LOG(ABS(Number))) AS theSum,
                      SUM(CASE WHEN Number < 0 THEN 1 ELSE 0 END) % 2 AS IsNegativeProduct
               FROM   YourTable
           ) AS d

Feedback

# Mother of the bride dresses.

Bridesmaid dresses. Wedding dresses. Girls holiday dresses. Formal dresses.

9/27/2010 2:04 PM | Dresses.

Comments have been closed on this topic.