Hats off Marks!!!!

i posted that pblm on all popular forums but u r the only one who solved my pblm 100%, although that query is very complicated for me to...

Exactly!!!

two or more than two consecutive 1's or 0's make those records suspicious.

A table containing alternatives 0 and 1 records will considered to be the perfect table, free from all...

You are absolutely right Lowell but what if I insert data like this:

--===== Insert the test data into the EMPLOYEE_CHECKINOUT table

INSERT INTO EMPLOYEE_CHECKINOUT

(

employeeID,

isCheckInOut,

timeInOut

)

SELECT 1,1,getdate() UNION ALL

SELECT 1,0,getdate() UNION ALL

SELECT 1,1,getdate()...

--===== Create the employee info table with

CREATE TABLE EMPLOYEE_INFO

(

employeeID INT IDENTITY(1,1) PRIMARY KEY,

employeeName VARCHAR(100)

...

Thanks alot Lowell!! but what if there are more than two consecutive duplicate records????an employee may checkin three,four,five...records on the same time. Should I use a loop here? Note that...