USE Northwind
GO

CREATE TABLE myTable99 (col1 int IDENTITY(1,1), col2 varchar(10), col3 datetime
	, PRIMARY KEY (col1))

CREATE UNIQUE INDEX IX1 ON myTable99 (col1)
WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

CREATE TRIGGER myTrigger ON myTable99
	FOR INSERT, UPDATE
AS
		UPDATE myTable99
		   SET myTable99.col2 = 'Expired'
		  FROM myTable99
	    INNER JOIN Inserted
		    ON Inserted.col1 = myTable99.col1
		 WHERE Inserted.col3 > GetDate()
GO

INSERT INTO myTable99 (Col2, col3)
SELECT 'Unexpired', '01/01/1990' UNION ALL
SELECT 'Unexpired', '01/01/1991' UNION ALL
SELECT 'Unexpired', '01/01/1992' UNION ALL
SELECT 'Unexpired', '01/01/1993'
GO

SELECT * FROM myTable99
GO

INSERT INTO myTable99 (Col2, col3)
SELECT 'Unexpired', '01/01/2045'

UPDATE myTable99 
   SET col3 = '10/01/2055' 
 WHERE col3 = '01/01/1990' 
GO
 
SELECT * FROM myTable99
GO

DROP TRIGGER myTrigger
GO

DROP TABLE myTable99
GO