On 11/1/18 1:23 PM, Rich Shepard wrote:
I have the following code in a script:
alter table stations add column start_date date;
alter table stations add column end_date date;
alter table stations add column howmany integer;
alter table stations add column bin_col char(8);
insert into stations (start_date, end_date, howmany, bin_col) values ( )
select site_nbr from stations
where site_nbr = ' ';
I am not following the above.
Are you trying to add new data to existing records?
If so where is the new data coming from?
The table has 82 rows. Is there a more elegant way to insert data
specific
to a site_nbr other than 82 repetitions of the insert statement? (I suspect
not, but I might be wrong and learn something valuable by asking.)
Regards,
Rich
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
