Responses inline...
On Tue, Sep 30, 2008 at 9:21 AM, Weston, Craig (OFT)
<[EMAIL PROTECTED]> wrote:
>
> Rob,
> I tried this on the small test data, a larger data set and it appears to
> make my day. I sincerely appreciate your willingness to help me out.
>
> I do have some questions, mostly so I c
k you.
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 10:11 AM
To: Weston, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: Many to many to too many relation.
Luck for you my vpn appears to be screwed up. Here is a stored proc I
whipp
e: Many to many to too many relation.
Luck for you my vpn appears to be screwed up. Here is a stored proc I
whipped up:
Stored procedure:
DROP PROCEDURE IF EXISTS s;
delimiter //
CREATE PROCEDURE s ()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE odone INT
> From: Rob Wultsch [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 30, 2008 3:30 AM
> To: Weston, Craig (OFT)
> Cc: mysql@lists.mysql.com
> Subject: Re: Many to many to too many relation.
>
> I tried reading this and it took much brain power to do for free. I
>
his e-mail or its
> attachments. Please notify the sender immediately by reply e-mail and
> delete the e-mail from your system.
>
>
> -Original Message-
>
> From: Rob Wultsch [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 30, 2008 3:30 AM
> To: Weston, Crai
from your system.
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 3:30 AM
To: Weston, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: Many to many to too many relation.
I tried reading this and it took much brain power to do for free. I
, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: Many to many to too many relation.
I tried reading this and it took much brain power to do for free. I
suggest breaking this down into the simplest possible example you can.
Ideally have an create table statement, and insert with a small amount
of
I tried reading this and it took much brain power to do for free. I
suggest breaking this down into the simplest possible example you can.
Ideally have an create table statement, and insert with a small amount
of data (as simple as possible), a simple psuedo code query and
example output of what yo
Hello everyone.
I have a complex situation. I have a list of related records (see
partial extract below) where I am trying to determine the unique lowest
number for each relation. This number should always be an AB number,
since all the MA numbers will always relate to an AB number. I need the
