i think op is still not clear about what he want,
ok one more guess
Hi OP What is the output of the below data
SELECT * FROM
(
VALUES
(1234,'03/31/2014','7.00','Monday'),
(1234,'04/01/2014','7.00','Tuesday'),
(1234,'04/02/2014','7.00','Wednesday'),
(1234,'04/03/2014','7.00','Thursday'),
(1234,'04/04/2014','7.00','Friday'),
(1234,'04/07/2014','8.00','Monday'),
(1234,'04/09/2014','8.00','Wednesday'),
(1234,'04/10/2014','8.00','Thursday'),
(1234,'04/11/2014','8.00','Friday'),
(1234,'04/12/2014','4.00','Saturday')
) AS vtable ([PERSON],[DATE],[HOURS],[DOW])
Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]