• can you post the data as consumable sql stateemtns we can paste into SSMS, along with the datatypes?

    something like this is an example

    ;WITH MyCTE([Times],[ACD],[Other],[Outb])

    AS

    (

    SELECT '8:30AM','0:00:00','0:00:00','0:00:00' UNION ALL

    SELECT '9:00AM','0:09:48','0:00:00','0:00:23' UNION ALL

    SELECT '9:30AM','0:15:20','0:02:27','0:00:00' UNION ALL

    SELECT '10:00AM','0:00:00','0:00:00','0:01:32' UNION ALL

    SELECT '10:30AM','0:00:00','0:00:00','0:00:00' UNION ALL

    SELECT '11:00AM','0:15:47','0:00:00','0:00:00' UNION ALL

    SELECT '11:30AM','0:00:33','0:00:00','0:00:00' UNION ALL

    SELECT '12:00PM','0:00:00','0:00:00','0:00:00' UNION ALL

    SELECT '12:30PM','0:00:00','0:00:00','0:00:00' UNION ALL

    SELECT '1:00PM','0:05:22','0:00:00','0:00:13' UNION ALL

    SELECT '1:30PM','0:00:04','0:00:00','0:12:25' UNION ALL

    SELECT '2:00PM','0:05:53','0:00:00','0:00:00' UNION ALL

    SELECT ''

    )

    SELECT * FROM MyCTE;

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!