var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What is structure of SQL Query to Resolve Chasm Trap
Database MS SQL Server 2005
My Database has two Fact tables and one Dimension table. Some complex calculation formulas involves both the fact tables and dimension table. But it creates traps and shows wrong result set.
Can anyone please suggest solution how this can be resolved?
What would be structure of SQL Query
Any help is appreciated.
Thanks in advance.
Most people won't want to do your homework for you.
Think about what you know about connection traps and how to avoid them.
Resolving Chasm Trap in SQL Query.
Thanks for your reply and sorry for not posting it in detail.
What I have tried -
1. I tried using Fact table 1 and Dimension table and Fact table two with Union ALL.
2. As per one article on net, I tried combination of left outer join.
But this also not helped. So looking if any one has resolved or knows a way toresolve it.
Last edited by Ashish Bhalerao; 04-14-09 at 06:44.
yes, i have
Originally Posted by Ashish Bhalerao
i can't help you with yours, however, because unfortunately my beta copy of Microsoft® CrystalBall© is down at the moment, so i cannot see your tables and therefore cannot show you how