RE: Point me in the Right Direction

[Andrew Scott]

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/sql@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists