I used this as an example to get what I needed; this is not the actual
design!! I used fields off the top of my head for this example:-)
Regards,
Andrew Scott
-----Original Message-----
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, 3 September 2001 4:27 AM
To: SQL
Subject: RE: Point me in the Right Direction
I would reconsider ur DB design. Looks as though the relationship
between
those two tables are 1 to 1. You could be adding complication and
overhead
for no reason.
Can you explain in more detail why you need this design?
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 02, 2001 7:14 AM
To: SQL
Subject: RE: Point me in the Right Direction
Sorry I was hoping for a bit more than that, I already can do that. I
was
looking for one that would do an entire recordset in one hit:-)
Regards,
Andrew Scott
-----Original Message-----
From: Brian Hogue [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 2 September 2001 11:52 AM
To: SQL
Subject: Re: Point me in the Right Direction
Andrew -
insert
into Table1
(Username
,Password)
select
Username,
Password
from
OldTable
and
insert
into Table2
(First_Name
,Last_Name
,Country
,Birth_Date)
select
First_Name,
Last_Name,
Country,
Birth_Date
from
OldTable
I think you want Table1 and Table2 to have a Primary Key (each).
-brian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
