SV: Help... How Do I?
From: (wrong string) öström <lasse.sjostrom_at_telia.com>
Date: 2000/05/14
Message-ID: <9QwT4.7273$Za1.113597_at_newsc.telia.net>#1/1
Date: 2000/05/14
Message-ID: <9QwT4.7273$Za1.113597_at_newsc.telia.net>#1/1
Harvey <harveyb_at_erols.com> skrev i
[Quoted] diskussionsgruppsmeddelandet:391E151D.93FA2B9F_at_erols.com...
> Hi All!
> select count(*) from seat_assignment where s_add_on_cd != 'N/A';
> insert into stats (logged_on, system_date) values ('<results of the
> above count>', sysdate)
>
> Thanks in Advance!
>
> Harvey
I think a
INSERT INTO STATS (l_o,s_d) select count(*).sysdate from seat_assignment
where s_add_on_cd != 'N/A';
will do the job for you.
Lars Received on Sun May 14 2000 - 00:00:00 CEST