No announcements
Found 136418 threads
-
0 VotesHow to Avoid Cartesian Product
Cartesian product in Access. AccessDiscussion | 2 Replies | 324 Views | Created by ryguy72 - Wednesday, May 25, 2016 1:45 PM | Last reply by Deepak Saradkumar Panchal - Thursday, May 26, 2016 5:38 AM
-
1 Votes
Cartesian product in SSIS?
Such a long procedure to perform a simple cartesian product. SSIS must really improve from this point of view. Here's a speculative ...Answered | 6 Replies | 4645 Views | Created by Trinakriae - Thursday, July 7, 2011 12:59 PM | Last reply by Jamie Thomson - Thursday, July 7, 2011 2:22 PM -
0 Votes
Cartesian product
Hi All, I have a table with a bunh of columns. I need to write a query to pull all the possible combinations(cartesian product) of columns Column1, Column2, ...Answered | 6 Replies | 1985 Views | Created by SnowShine429 - Sunday, February 17, 2013 6:13 AM | Last reply by Rahul Kumar (Rahul Vairagi) - Sunday, February 17, 2013 6:42 PM -
0 Votes
t-sql void cartesian product
cartesian product. I am trying to determine how to run the queries I need to run without getting the cartesian ...Answered | 12 Replies | 2659 Views | Created by wendy elizabeth - Monday, December 24, 2012 9:43 PM | Last reply by Naomi N - Thursday, December 27, 2012 11:29 PM -
1 Votes
What is the use of Cartesian Product or Cross join?
Dear friends... I have done with inner join, self join and outer join. But I m getting confused with cross join. I know it used to produce Cartesian ...Answered | 2 Replies | 1024 Views | Created by TAUSEEF DEVELOPER - Wednesday, March 25, 2015 6:16 AM | Last reply by Vaibhav.Chaudhari - Wednesday, March 25, 2015 6:40 AM -
1 Votes
generate Cartesian product of values
Hi eb How would you create a Cartesian product of sets of values (values are not in any table). Ex. Set1 {1:2},Set2 {3:4}. You could ...Answered | 3 Replies | 497 Views | Created by reapeleg - Friday, May 26, 2017 7:37 AM | Last reply by Jason A Long - Friday, May 26, 2017 8:23 PM -
0 Votes
Joins between two tables generating Cartesian product
Hi, Can you please post your script to see what is causing the cartesian product? This way it is difficult to help you. ...Answered | 3 Replies | 553 Views | Created by Anu Ashokan - Friday, February 27, 2015 7:20 AM | Last reply by Jingyang Li - Friday, February 27, 2015 2:28 PM -
0 Votes
the Cartesian product of arrX and ArrY
-------------------------------------------------------- Task: Convert TextBox9 content in arrX-array and TextBox7 content in arrY-array and performing ...Unanswered | 1 Replies | 674 Views | Created by AbkarovKhalid - Saturday, January 4, 2014 5:02 PM | Last reply by Acamar - Saturday, January 4, 2014 8:55 PM -
0 Votes
Cartesian Product Query/Data model question
I am using cartesian product fact table and have employee dimension division and department dimensions .As these 2 tables are not dependent i am taking ...Unanswered | 1 Replies | 409 Views | Created by SPRRAc - Tuesday, August 21, 2018 12:12 AM | Last reply by Will_Kong - Tuesday, August 21, 2018 3:07 AM -
0 Votes
Help using SF to generate a Cartesian Product?
able to generate a cartesian product using LINQ. What I don't have is and adequate constraints API for it. Now FYI I did actually manage to get it to generate the ...Answered | 2 Replies | 2974 Views | Created by Jonny Garrett - Thursday, November 29, 2012 10:54 PM | Last reply by Jonny Garrett - Friday, November 30, 2012 5:34 PM -
0 Votes
Unpivot avoid cartesian product on empty columns
My issue is that by the nature of UNPIVOT, the result is the cartesian product of departement, nif and pays_fiscal. Which means that I will always have 90 rows for eachAnswered | 4 Replies | 684 Views | Created by MTH_CH - Thursday, October 18, 2018 12:47 PM | Last reply by MTH_CH - Thursday, October 18, 2018 4:52 PM -
0 Votes
Stumped...cartesian product brain teaser
I have a table with 2 columns as follows: COORD LEVEL===== =====1 11 22 23 ...Answered | 6 Replies | 6279 Views | Created by Jim Bennett - Thursday, May 10, 2007 7:45 PM | Last reply by Kent Waldrop _ - Thursday, May 10, 2007 7:52 PM -
0 Votes
Can inflated aggregate results from a cartesian product be avoided?
cartesian product. I thought a subquery for each of the fields being summed would help; again, a generic example: SELECTAnswered | 8 Replies | 4547 Views | Created by cgwaters - Thursday, July 31, 2008 10:03 PM | Last reply by Jonathan Kehayias - Thursday, July 31, 2008 11:04 PM -
5 Votes
Avoid cartesian Product rows using SQL query
rows(It's a cartesian product and want to avoid multiple rows for same ID and dates), show each TransID with associated TransDate 4 ...Unanswered | 13 Replies | 1704 Views | Created by sql9 - Tuesday, April 26, 2016 4:11 AM | Last reply by Patrick Hurst - Tuesday, April 26, 2016 4:59 PM -
1 Votes
Join Problems - Getting Cartesian Product (cross join)
I am trying to write a stored proc that returns data from several tables but I am getting a Cartesian product (cross join) and I am having problems getting rid of itAnswered | 6 Replies | 9469 Views | Created by A-J - Wednesday, November 12, 2008 4:07 PM | Last reply by kiranshiva - Monday, March 19, 2012 6:27 PM -
1 Votes
Where is the SSIS Task "Cartesian product"
I would like to have a SSIS Task "Cartesian product", so I get the Number 09 in my SQLAnswered | 7 Replies | 5083 Views | Created by Johannes Cramer - Thursday, July 22, 2010 4:45 PM | Last reply by Johannes Cramer - Sunday, July 25, 2010 5:02 PM -
0 Votes
Issue with sink transformation: Detected implicit cartesian product for INNER join between logical plans\nTypedFilter
': Detected implicit Cartesian product for INNER join between logical plans\nTypedFilter". For additional info In the dataUnanswered | 1 Replies | 480 Views | Created by vidya.s - Friday, March 29, 2019 6:36 AM | Last reply by HimanshuSinha-msft - Tuesday, April 2, 2019 5:01 PM -
0 Votes
left outer join produces cartesian product
Tables have 100K rows. Inner join produces 99k. The outer join should be 100K. It is 1000 times larger. If I do a SELECT DISTINCT, the right # rows are ...Unanswered | 1 Replies | 6992 Views | Created by LKHall - Thursday, February 9, 2006 4:57 PM | Last reply by Jamie Thomson - Thursday, February 9, 2006 5:14 PM -
0 Votes
Does ANY join startement WILL always do a cartesian product of 2 tables before matching where or on condition ?
The logical query processing phase includes a cartesian product and then apply the ON or WHERE conditions based on the join types. However to optimize the performance SQL Server ...Answered | 2 Replies | 2656 Views | Created by Sridhar Rajan Venkataramani - Saturday, February 18, 2012 10:11 AM | Last reply by Krishnakumar S - Saturday, February 18, 2012 11:27 AM -
0 Votes
Is there any way to tell in SQL Server Management Studio if I have a cartesian product?
If you have a normal join, you should not be getting a cartesian product. Why don't you try looking at the estimated execution plan to see what is taking so ...Answered | 4 Replies | 1384 Views | Created by PSULionRP - Wednesday, July 31, 2013 1:42 PM | Last reply by wBob - Thursday, August 1, 2013 1:18 AM - Items 1 to 20 of 136418 Next ›
No announcements
