Basic INSERT question

[jpillonel]

Hello,

I have a basic question regarding an insert.

This is what I actually do on DTS package on ms sql 2000:

" insert into logtable (Rows_before)
(select count(no_empl) from assures) "

I want to change to add a new "static" value like this but it doesn't works, any have an idea ???

" insert into logtable (domaine, Rows_before)
VALUES ('assur', (select count(no_empl) from assures)) "

Thanks for your help

 

[r937]

insert 
  into logtable 
     ( domaine
     , Rows_before )
select 'assur'
     , count(no_empl) 
  from assures

r937.com | rudy.ca

 

[jpillonel]

Works fine ! Thanks.