• geert.de.vylder (3/1/2013)


    Hi Cadavre,

    Thank you for your help and assistance.

    Can you explain me what happens per step. I ask this because the result does not group the columns per interval and not all the 96 intervals (quarters per hour) are represented in the result.

    Your explanation will help me to improve the query.

    Thank you very much for what you do for me.

    Greetz,

    Geert

    I have no idea what you're asking me.

    Script out your expected results based on your sample data and I'll see if I can work out what you want.


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/