• timothyawiseman>: no I am not passing it from a CSV. I am actually pulling it from my DB and when I run my SP it returns the data that way...

    GSquared>: thank you, that is defently a different way to write it that I didn't think about. However, your query returns every dls.TimeStampUTC

    For example my data looks something like this:

    2008-01-01 05:00:00.000

    2008-01-01 05:15:00.000

    2008-01-01 05:30:00.000

    2008-01-01 05:45:00.000

    2008-01-01 06:00:00.000

    2008-01-01 06:15:00.000

    2008-01-01 06:30:00.000

    2008-01-01 06:45:00.000

    2008-01-01 07:00:00.000

    ....

    as you can see above the time is in 15 mn increments, but I am only interested in calculating energy consumed each hour. For example from 5:00 - 6:00, 6:00 to 7:00, 7:00 to 8:00 etc. etc... for a 24 hour period.

    thanks again,


    Abdel Ougnou