The-Center-3004 23/11/2009 9:50 23/11/2009 9:51 SOP Status
The-Center-3004 23/11/2009 9:52 23/11/2009 10:00 SOP Status
The-Center-3004 23/11/2009 9:53 23/11/2009 10:00 Out of order
The-Center-3004 04/12/2009 10:49 04/12/2009 10:52 SOP Status
The-Center-3004 04/12/2009 10:52 04/12/2009 10:52 Network
The-Center-3004 04/12/2009 10:55 04/12/2009 10:55 Out of order
The-Center-3004 05/11/2009 9:45 05/11/2009 9:51 SOP Status
The-Center-3004 05/11/2009 9:45 05/11/2009 9:51 Out of order
The-Center-3004 25/11/2009 5:17 25/11/2009 5:31 Network
The-Center-3004 25/11/2009 5:17 25/11/2009 5:31 Out of order
The-Center-3004 25/11/2009 7:17 25/11/2009 7:17 Network
i have one table select siteid,startdat etime,enddateti me,status i want only one record if the time period in between previous record for ur ref (in italic font ) i want only one record out of all records which are italic and bold
The-Center-3004 23/11/2009 9:52 23/11/2009 10:00 SOP Status
The-Center-3004 23/11/2009 9:53 23/11/2009 10:00 Out of order
The-Center-3004 04/12/2009 10:49 04/12/2009 10:52 SOP Status
The-Center-3004 04/12/2009 10:52 04/12/2009 10:52 Network
The-Center-3004 04/12/2009 10:55 04/12/2009 10:55 Out of order
The-Center-3004 05/11/2009 9:45 05/11/2009 9:51 SOP Status
The-Center-3004 05/11/2009 9:45 05/11/2009 9:51 Out of order
The-Center-3004 25/11/2009 5:17 25/11/2009 5:31 Network
The-Center-3004 25/11/2009 5:17 25/11/2009 5:31 Out of order
The-Center-3004 25/11/2009 7:17 25/11/2009 7:17 Network
i have one table select siteid,startdat etime,enddateti me,status i want only one record if the time period in between previous record for ur ref (in italic font ) i want only one record out of all records which are italic and bold