CREATE TABLE CodeReviewRecord
([Id] INTEGER PRIMARY KEY,[Title] nvarchar( 50 ) not null,[Description] nvarchar( 255 ) null,
[SeverityId] int not null,[StatusId] int not null,[OwnerId] int not null,
[AssignedId] int not null,[CreatedDate] datetime not null,
[EditorId] int not null,[ChangeDate] datetime not null,[Resolution] text null);

CREATE TABLE Status
([StatusId] int not null primary key,[StatusName] nvarchar( 30 ) not null);

INSERT INTO [Status] VALUES( 1 ,'Active');
INSERT INTO [Status] VALUES( 2 ,'Failed');
INSERT INTO [Status] VALUES( 3 ,'Fixed');
INSERT INTO [Status] VALUES( 4 ,'Closed');
INSERT INTO [Status] VALUES( 5 ,'Skipped');

CREATE TABLE CodeReviewRecordHistory
([Id] INTEGER PRIMARY KEY,
[CRRId] int not null,[EditorId] int not null,[ChangeDate] datetime not null,[StatusId] int not null,
[Resolution] text null,[SeverityId] int not null);

CREATE TABLE Users
([UserId] INTEGER PRIMARY KEY,[UserName] nvarchar( 60 ) not null,[Password] nvarchar( 50 ) not null,
[ReviewerId] int not null,[LastLoginTime] datetime null,[Role] nvarchar( 50 ) null,
[CreatedDate] datetime null,[SharepointId] nvarchar( 255 ) not null);

SELECT CodeReviewRecord.Id,CodeReviewRecord.Title,CodeReviewRecord.Description,CodeReviewRecord.SeverityId,
CodeReviewRecord.StatusId,CodeReviewRecord.OwnerId,CodeReviewRecord.AssignedId,CodeReviewRecord.CreatedDate,
CodeReviewRecordHistory.EditorId,CodeReviewRecordHistory.ChangeDate,CodeReviewRecord.Resolution
FROM CodeReviewRecord INNER JOIN Status On CodeReviewRecord.StatusId=Status.StatusId
INNER JOIN Users ON CodeReviewRecord.OwnerId=Users.UserId AND Users.UserName='Tmp user'
INNER JOIN CodeReviewRecordHistory On CodeReviewRecord.Id= CodeReviewRecordHistory.CRRId
AND CodeReviewRecordHistory.ChangeDate BETWEEN @p1 and @p2
WHERE Status.StatusName='Skipped'  

SELECT CodeReviewRecord.Id,CodeReviewRecord.Title,CodeReviewRecord.Description,CodeReviewRecord.SeverityId,
CodeReviewRecord.StatusId,CodeReviewRecord.OwnerId,CodeReviewRecord.AssignedId,CodeReviewRecord.CreatedDate,
CodeReviewRecordHistory.EditorId,CodeReviewRecordHistory.ChangeDate,CodeReviewRecord.Resolution
FROM CodeReviewRecord INNER JOIN Status On CodeReviewRecord.StatusId=Status.StatusId
INNER JOIN Users ON CodeReviewRecord.OwnerId=Users.UserId
INNER JOIN CodeReviewRecordHistory On CodeReviewRecord.Id= CodeReviewRecordHistory.CRRId
WHERE Status.StatusName='Skipped'  AND Users.UserName='Tmp user'
AND CodeReviewRecordHistory.ChangeDate BETWEEN @p1 and @p2