Ok just been fiddling with a few things and getting no where.
Can someone show me how, here is a sample table
Fields used as a test.
First_Name
Username
Password
Country
Birth_Date
I wish to have now
Table 1
Username
Password
Table 2
First_Name
Last_Name
Country
Birth_Date
Just something to get me going would be good, many thanks!!
Regards,
Andrew Scott
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 2 September 2001 12:34 AM
To: SQL
Subject: RE: Point me in the Right Direction
Ok thanks all,
Yes it is a one time execution, ok maybe a sql query would be the best
thing from what I have read so far. I was just curious on my optiond,
because I have about 20 fields in one table that instead of being index
to another table holds the same data over and over again, which I
consider a waste of space.
So there is a bit of processing of data that needs to be done after the
read but before the write.
Well I was also thinking of taking the DB off line, when the site is not
at its busiest and run this query and have it done as quickly as
possible. If a view would be better, I am open to suggestions on what
would be best.
Regards,
Andrew Scott
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
