Sorry, should be more explicit:

Based on a similar table, adding a column to the schema for shift number ('1' being 1st shift,'2' being 2nd shift ,'3' being 3rd shift).

CREATE TABLE...

Data sorted by shift...

The shifts are as stated :

7:01AM to 4:30PM -1st shift

4:31PM to 1:10AM - 2nd Shift

1:11AM to 7:00AM - 3rd Shift

Here you go:

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable

(HeaderID INT IDENTITY(1,1)...

I would love to do a CAST(DateTested as Time) but that data type (Time) is not supported in SQL 2005 (unfortunately this is not something I can control, legacy data...