sql server data mining: 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

excuse my ignorance but what is "DDL"? i'm new at some of this...



*** Sent via Developersdex http://www.developersdex.com ***

You can use some sort of grouping or distinct within Crystal, been a long
time since I used crystal though. The grouping records option is probably
what you need. Or, if you only need numbers and not a pretty report, submit
your DDL and I'm sure someone can write the appropriate query.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]

From BOL (booksonline)

Data Definition Language (DDL), which is used to define and manage all the
objects in an SQL database, and Data Manipulation Language (DML), which is
used to select, insert, update, and delete data in the objects defined using
DDL. The Transact-SQL DDL used to manage objects such as databases, tables,
and views is based on SQL-92 DDL statements, with extensions. For each
object class, there are usually CREATE, ALTER, and DROP statements, such as
CREATE TABLE, ALTER TABLE, and DROP TABLE. Permissions are controlled using
the SQL-92 GRANT and REVOKE statements, and the Transact-SQL DENY statement.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]