Andrew -
If this transfer is a one time issue, I would not use SPs. I would use an SP where I
have to do a set of steps over
and over. Building an SP means debugging ... which is testing out the statements
(steps) inside the SP ... so if it
is a one time conversion, then you are done when you complete SP unit testing.
To 'copy' data from one table to another try SQL Inserts with the Into parameter ...
insert
YourColumns
into
NewTable
from
OldTable
You could execute this as an Insert statement or inside a SP.
If you want to 'copy' data every time a row is inserted into OldTable, you have three.
1) a Trigger, which fires off when a row is inserted into OldTable ... the DBMS does
the automated firing ... after
you set up the Trigger.
2) after the existing SQL Insert into OldTable, execute the above Insert Into From as
a second SQL statement
3) a variation of 3 ... execute the SP as the second SQL statement
hth
-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
