```
Date    Time    Event   site
2017-03-29  13:09:31.0000000    IN  Old Site
2017-03-29  14:26:32.0000000    OUT Old Site
2017-03-29  14:41:02.0000000    IN  Old Site
2017-03-29  16:21:17.0000000    OUT Old Site
2017-03-29  16:54:18.0000000    IN  Old Site
2017-03-29  16:54:24.0000000    IN  Old Site
2017-03-29  17:45:05.0000000    OUT Old Site
2017-03-29  19:30:03.0000000    IN  Old Site

```

---

```
DECLARE @empTime TABLE ([Date] DATE,[Time] TIME,[Event] VARCHAR(30),[Site] VARCHAR(30))

INSERT INTO @empTime ([Date],[Time],[Event],[Site])
VALUES
('2017-03-29', '13:09:31.0000000', 'IN', 'Old Site'),
('2017-03-29', '14:26:32.0000000', 'OUT', 'Old Site'),
('2017-03-29', '14:41:02.0000000', 'IN', 'Old Site'),
('2017-03-29', '16:21:17.0000000', 'OUT', 'Old Site'),
('2017-03-29', '16:54:18.0000000', 'IN', 'Old Site'),
('2017-03-29', '16:54:24.0000000', 'IN', 'Old Site'),
('2017-03-29', '17:45:05.0000000', 'OUT', 'Old Site'),
('2017-03-29', '19:30:03.0000000', 'IN', 'Old Site')

SELECT *
FROM @empTime

```

As per above code and output, I want to remove one of the Record for `'IN' '16:54:24.0000000'` because I want record in form of continuous `IN-OUT-IN-OUT`.

I want to remove duplicate occurrence of value in below record. I want record should be in continuous form `i.e. In-Out-In-Out.`