Home Forums SQL Server 2008 T-SQL (SS2K8) Grouping records by time interval RE: Grouping records by time interval

  • March 6, 2013 at 9:12 am

    #1594030

    geert.de.vylder (3/6/2013)

    ChrisM@Work (3/6/2013)

    I've no idea, Geert. Folks here on SSC will help you with coding decisions; this is more of a business decision. A date filter seems sensible to me but is it appropriate for the consumers of the data? How many days' worth of data are other folks expecting to see?

    We would like to see a month worth of data. Let's say February.

    How about "all data for last month - which as of today will be February"?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden