SET NOCOUNT ON

-- the source table
CREATE TABLE	test_source	(
		order_no	VARCHAR(10)	NOT NULL
	,	line_no		INT			NOT NULL
	,	item		VARCHAR(10)	NOT NULL
	,	descrip		VARCHAR(50)	NOT NULL
	)
GO

-- the destination table
CREATE TABLE	test_dest	(
		order_no	VARCHAR(10)	NOT NULL
	,	line_no		INT			NOT NULL
	,	other_col	VARCHAR(50)	NULL
	)
GO

-- CREATE TRIGGER -- not sure how to write conditional trigger so will leave this off

-- some inserts for testing purposes
INSERT INTO	test_source	VALUES	('145',1,'ITEM1','First Item')
INSERT INTO	test_source	VALUES	('145',2,'SOMITEM','Some Item')
INSERT INTO	test_source	VALUES	('145',3,'THEVAL','Triggering Item 1')
INSERT INTO	test_source	VALUES	('145',4,'THEVAL','Triggering Item 2')
INSERT INTO	test_source	VALUES	('145',5,'ITEM5','Fifth Item')
INSERT INTO	test_source	VALUES	('145',6,'THEVAL','Triggering Item 3')
INSERT INTO	test_source	VALUES	('145',7,'LSTITEM','Last Item')

-- check for created records in destination table
SELECT	*	FROM	test_dest

-- clean up
DROP TABLE		test_source
GO

DROP TABLE		test_dest
GO

SET NOCOUNT OFF

create trigger TR_test_source
on
	test_source
for
	insert
as

insert into test_dest
	(
	order_no,
	line_no
	)
select
	order_no,
	line_no
from
	inserted
where
	item = 'THEVAL'