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@aklaver.com