half Of Judd
> Pickell
> Sent: Tuesday, June 17, 2008 1:37 PM
> To: Main PLUG discussion list
> Subject: Re: SQL Question - Complex ordering
>
>> Also, I do not use stored procedures because the criteria changes with
>
>> every run. Think of it like going to the cable com
lto:[EMAIL PROTECTED] On Behalf Of Judd
Pickell
Sent: Tuesday, June 17, 2008 1:37 PM
To: Main PLUG discussion list
Subject: Re: SQL Question - Complex ordering
> Also, I do not use stored procedures because the criteria changes with
> every run. Think of it like going to the cable company and a
> Also, I do not use stored procedures because the criteria changes with
> every run. Think of it like going to the cable company and asking to
> have a cable package put together where you choice from millions of
> different channels based on your interest in the programs run on those
> channels.
Sent: Saturday, June 14, 2008 6:40 PM
To: Main PLUG discussion list
Subject: Re: SQL Question - Complex ordering
Why in the world would you insert data already existing in tables into
yet another table? Judging from your requirement, you are not changing
the data in any way, simply gathering it
Why in the world would you insert data already existing in tables into
yet another table? Judging from your requirement, you are not changing
the data in any way, simply gathering it. So why have data in two
places? If you do, you're headed for un-reliability-ville. imho
If you REALLY need to crea
: Saturday, June 14, 2008 3:11 PM
To: Main PLUG discussion list
Subject: Re: SQL Question - Complex ordering
I'd ask why you need this complex of a data model, but I'm afraid of the
answer
With this many complex and overlapping conditions, you're almost
certainly better off perform
, FEILD_B, FEILD_C FROM TEMP
From: Bryan O'Neal
Sent: Saturday, June 14, 2008 1:01 PM
Subject: SQL Question - Complex ordering
Ok, I have TABLE-1, TABLE-2, TABLE-3, TABLE-4,TABLE-5 involved
TABLE-1 is a 1 to many on TABLE-2
TABLE-1 is a 1 to many on TABLE
I'd ask why you need this complex of a data model, but I'm afraid of the
answer
With this many complex and overlapping conditions, you're almost certainly
better off performing the desired transformation in a separate program (written
in Java, Python, or something similar).
You'd read the s
Ok, I have TABLE-1, TABLE-2, TABLE-3, TABLE-4,TABLE-5 involved
TABLE-1 is a 1 to many on TABLE-2
TABLE-1 is a 1 to many on TABLE-3
TABLE-1 is a 1 to many on TABLE-4
TABLE-2 has a primary key of (TABLE-1_ID, TABLE-3_ID)
I want to insert records into TABLE-2 based on information in TABLE-1
and TABL