Mr.Cetin,

Thanks for your reply,

The Reason is, i m working on Employees Attendance project, in that some employe they are
working in different Job in same day.
(For Eg. Emplyee 'A' From 08 To 09 Job(1)
'A' From 10 To 13 Job(2)
'A' From 14 To 17 Job(3) etc.
.......................
Emplyee 'B' From 08 To 17 Job(1)

So, how will i manage these types trasactions Using SQL Statements.

Regards
Abdulla