Listing 1: Creating and Populating the TimeStamps Table

SET NOCOUNT ON;
USE tempdb;
GO
IF OBJECT_ID('dbo.TimeStamps', 'U') IS NOT NULL
  DROP TABLE dbo.TimeStamps;
GO
CREATE TABLE dbo.TimeStamps
(
  keycol  INT      NOT NULL PRIMARY KEY,
  from_ts DATETIME NULL,
  to_ts   DATETIME NULL
);
INSERT INTO dbo.TimeStamps(keycol, from_ts, to_ts)
  VALUES(1, '20040229 12:00:00.000', '20050228 13:00:00.000');
INSERT INTO dbo.TimeStamps(keycol, from_ts, to_ts)
  VALUES(2, '20030321 14:27:12.233', '20060115 11:45:22.263');
INSERT INTO dbo.TimeStamps(keycol, from_ts, to_ts)
  VALUES(3, '20060115 11:45:22.263', '20030321 14:27:12.233');
INSERT INTO dbo.TimeStamps(keycol, from_ts, to_ts)
  VALUES(4, '20060212 00:00:00.000', '20060212 00:00:00.000');
INSERT INTO dbo.TimeStamps(keycol, from_ts, to_ts)
  VALUES(5, '20051231 23:59:59.997', '20060101 00:00:00.000');
INSERT INTO dbo.TimeStamps(keycol, from_ts, to_ts)
  VALUES(6, '17530101 00:00:00.000', '99991231 23:59:59.997');
GO