• 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]