Insert query 1

[NeilV]

Hello,

I am trying to write an SQL insert that gets some values from another table and some values created from elsewhere. What i would like to do is:

insert into table1
(Board,entity,info,value,clocked)
values('A','B','C',select value from table2 where info=123,getDate())

Is something like this possible - if so how?

Cheers,

Neil

 

[swampBoogie]

insert into table1
(Board,entity,info,value,clocked)
select 'A','B','C', value, getdate()  
from table2 
where info=123

 

[dbomrrsm]

I thinks swampboogie may have misinterpreted what you want - if so and appologies if swampboogie hasnt ! try

insert into table1
(Board,entity,info,value,clocked)
values'A','B','C',(select value from table2 where info=123),getDate()

DBomrrsm

 

[NeilV]

Thanks for that SwampBoogie,it did the trick!

 

[dbomrrsm]

And appologies to swampboogie from DBomrrsm !!