LISTING 1: Code to Create and Populate the Repairlog Table

CREATE TABLE Repairlog
(
  repairno int      NOT NULL,
  status   int      NOT NULL,
  regdate  datetime NOT NULL
  PRIMARY KEY(repairno, status, regdate)
)

SET NOCOUNT ON

INSERT Repairlog VALUES(1,  0, '20010101')
INSERT Repairlog VALUES(1, 21, '20010102')
INSERT Repairlog VALUES(1, 20, '20010102')
INSERT Repairlog VALUES(1, 30, '20010103')

INSERT Repairlog VALUES(2, 20, '20010104')
INSERT Repairlog VALUES(2, 30, '20010104')

INSERT Repairlog VALUES(3,  0, '20010101')
INSERT Repairlog VALUES(3, 20, '20010102')
INSERT Repairlog VALUES(3, 21, '20010103')
INSERT Repairlog VALUES(3, 30, '20010103')
INSERT Repairlog VALUES(3, 21, '20010104')
INSERT Repairlog VALUES(3, 30, '20010104')