Is there a relatively simple way to insert multiple rows into a table in which the data being inserted comes from both a select statement and hard-coded data?
For example,
insert into tblB
(field1, field2, field3)
values
( 950, select fieldA, fieldB from tblA )
...where 950 is a hard-coded value and fieldA
and fieldB
come from tblA