I'm asking this just for fun folloing a long standing discussion at work...
Does anyone know of a decent real-world situation where a cartesian join is actually useful and/or preffered
?
I can...
http://www.experts-exchange.com/Database/Oracle/Q_20439756.html
Zones:
OracleDate Answered: 01/20/2003 Rating: 7.4 Views: 0
I am developing a query builder form something similar to TOAD.
When the user selects multiple columns from various tables i need to detect whether the tables can be joined or not. I want this to ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20957365.html
Zones:
DatabasesDate Answered: 05/18/2004 Rating: 8.8 Views: 0
Dear All
I have several arrays in my program :
int set1[] = {1,2,3,5};
int set2[] = {4,6,7};
int set3[] = {11,22,76,71};
I need to perform an operation on these arrays in several...
http://www.experts-exchange.com/Programming/Languages/Java/Q_22026918.html
Zones:
JavaDate Answered: 10/18/2006 Rating: 9.4 Views: 0
This could be simple but I am going crazy tring to figure this out.
There are four tables
1. Courses - hold Course data
2. Programs - holds only ProgramID and Program Text
3. Prerequisite...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22145086.html
I'm trying to do transformations to and from spherical coords using DirectX9. There doesn't seem to be a convenient method in the DX framework, so I found a what looked like a good xform at: http:...
http://www.experts-exchange.com/Programming/Game/3D_Prog./Q_20711610.html
hi
i have 2 table SEMINARSESSIONS, SEMINARDETAILS
SEMINARDETAILS has SEMINARID as the PK which is the foreign key in SEMINARSESSIONS (whose PK is SESSIONID).
I am doing a simple retrieval a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21543123.html
Zones:
MS SQL ServerDate Answered: 08/29/2005 Rating: 8.6 Views: 0
To create my example:
drop table table1
drop table table2
create table table1 (let char(1))
create table table2 (let char(1))
insert into table1 values ('a')
insert into table1 values ('b')...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22068508.html
Zones:
MS SQL ServerDate Answered: 11/21/2006 Rating: 8.8 Views: 0
Hi all,
For a project i'm doing I am extending a piece of software and implementing a fisheye affect to a grid.
I can find algorithms for normal grids but i need the focus points width and he...
http://www.experts-exchange.com/Programming/Algorithms/Q_23006246.html
this is a view that I have and for some reason it is displaying way too many records in the database could there be a possible cartesian product going on?
SELECT dbo.aspnet_Users.UserId, d...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21800535.html
Zones:
MS SQL ServerDate Answered: 04/11/2006 Rating: 5.0 Views: 0
how to avoid cartesian product while getting values through sum of the two columns from two tables?
Both the tables have the same structure!!!
Any one Please help me!
If U need I will send m...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20410770.html
Zones:
MS AccessDate Answered: 03/22/2003 Rating: 9.2 Views: 4