SQL 2000 INSERT Statement 1

[BillBrosius]

Is it possible to use the INSERT INTO statement in a stored procedure that would include a both a SELECT statement and static values? For example,

INSERT INTO #table1 (Field1) VALUES ("CASH")
INSERT INTO #table1 (Field2,Field3,Field4)
Select field2,field3,field4 From table2

Can the above INSERT Statements be combined into one statement to form one record?

Thanks.

 

[jhall01]

INSERT INTO #table1
SELECT 'cash', field2, field3,field4
FROM table2

 

[BillBrosius]

Thank you!!