Kent,

	It'd help if you could post the actual SQL code rather than a
description.


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Kent Wallace
Sent: Friday, November 21, 2008 12:57 PM
To: [log in to unmask]
Subject: [HP3000-L] ot: ms sql MULTIPLE Cartesian

I have a large stored procedure that is left joining from fact table to
dimension tables.  I use about 20 left joins to dimension tables.  I am
getting Multiple Cartesians.

 

 

I tried:

 

1.	A right join back into the same table using distinct. (no luck)
2.	Now I am trying a group by and order by.   To do this I must put
an aggregate function on ever field.  I am using MAX.

 

 

Does anyone have an elegant solution to this problem?

 

Kent Wallace - Business Intelligence Developer

Healthcare Management Administrators Inc

Phone - 425-289-5267

 

 



--------------------------------------------------------------------
NOTICE:
Please note that my e-mail address has changed.   
Please save my new address to your contacts list by right clicking on my
name
 in the header of this message and selecting the option "add to outlook
contacts".   
Please delete my old e-mail with the domain of @hma.regence.com.  Thank
you.


DISCLAIMER:
The information in this message is confidential and may be legally
privileged. 
It is intended solely for the addressee. Access to this message by
anyone else is unauthorized. 
If you are not the intended recipient, any disclosure, copying, or
distribution of the message,
or any action or omission taken by you in reliance on it, is prohibited
and may be unlawful. 
Please immediately contact the sender if you have received this message
in error. Thank you

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *