Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: sum

Re: sum

From: Joe \ <joe_at_bftsi0.UUCP>
Date: Thu, 4 Dec 2003 09:35:06 -0800
Message-ID: <1070560304.42475@news-1.nethere.net>


"Michael Sterling" <stermic_at_gw.co.jackson.mo.us> wrote in message <news:f7359f44.0312040758.e6dd3be_at_posting.google.com>...

> i'm trying to run a crystal report with a sum of a certain column of
> dollar amounts. the problem is that there are certain instances where
> some of the records are duplicated and unfortunately the duplicated
> dollar amount is added into the total at the end. i'd like to know how
> to prevent this from happening.

Now that you have seen what "denormalizing for performance" really gets you, get a new DBA and normalize your database.

--
Joe Foster <mailto:jlfoster%40znet.com>  Sacrament R2-45 <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!
Received on Thu Dec 04 2003 - 11:35:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US