I have a table that stores spot info for our tape label system. I want to
be able to copy all records with a specific librarynumber back into the
same table, but with a different librarynumber.
Something similar to this (which of course does not work)
select into tblspotinfo (librarynumber) values ('6666') select spotnumber,
spottitle, isci, trt, date, timecode from tblspotinfo where librarynumber
= '9988';
Of course it does not like me overloading the select into command like
that. Is there a simple way to do this that I am just missing? I just
want to duplicate the data related to librarynumber 9988 and make the new
librarynumber 6666.
Thanks for any insight,
Walt