can you please provide sample ORDER_DETAILS data for Smith Jones and Andrews.
you can "remember" by using the INSERTED. feature of sql to a table variable and dump the inserted data into that table variable
declare @Order_Header table(ORDERSYSTEM_ORDER_ID int, ORDERSYSTEM_DATE datetime, ORDERSYSTEM_LASTNAME varchar(255))
create table dbo.Order_Header(ORDERSYSTEM_ORDER_ID int, ORDERSYSTEM_DATE datetime, ORDERSYSTEM_LASTNAME varchar(255))
insert into dbo.Order_Header
select 111, '4/12/2012', 'Smith'
UNION
Select 222, '4/28/2012' , 'Jones'
UNION
SELECT 333 , '5/8/2012' , 'Andrews'
create table dbo.Order_Header_part_deux(ORDERSYSTEM_ORDER_ID int, ORDERSYSTEM_DATE datetime, ORDERSYSTEM_LASTNAME varchar(255) )
insert into dbo.Order_Header_part_deux
OUTPUT INSERTED.ORDERSYSTEM_ORDER_ID, INSERTED.ORDERSYSTEM_DATE, INSERTED.ORDERSYSTEM_LASTNAME
INTO @Order_Header
select 111, '4/12/2012', 'Smith'
UNION
Select 222, '4/28/2012' , 'Jones'
UNION
SELECT 333 , '5/8/2012' , 'Andrews'
select * from @Order_Header
drop table Order_Header_part_deux
drop table Order_Header
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Insert multiple Order Header IDs into OrderDetail?
Posted - 05/22/2012 : 12:39:04
)
