Bones of SQL – Grouping By User-Defined Calendar Periods

  • The Dixie Flatline

    SSC Guru

    Points: 53253

    Comments posted to this topic are about the item Bones of SQL – Grouping By User-Defined Calendar Periods

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    You're too modest. It's not just for newcomers. Us old folks forget the simple things and can use reminders now and then.

  • DataTherapist

    Mr or Mrs. 500

    Points: 510

    Bob:

    Love it! so elegant.... thanks for sharing.

    Peter A.R. Johnson

    Data Therapist

    Federal Way Public Schools

    Federal Way, WA

  • The Dixie Flatline

    SSC Guru

    Points: 53253

    I have to ask... just what is a Data Therapist? 🙂

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • sknox

    SSChampion

    Points: 12292

    Of course, for user-defined periods which are used often, the best thing to do is to add these calculations into the generation of your calendar table ( http://www.sqlservercentral.com/articles/calendar/145206/ )...

  • The Dixie Flatline

    SSC Guru

    Points: 53253

    How can I argue with that? 😀

    Some people have yet to implement a calendar table though. Even those who have might get asked for a period which they did not anticipate, like dividing the year into ten 35-day periods, and some holiday leftovers.

    Thanks for paying attention, Mr. Knox.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • DataTherapist

    Mr or Mrs. 500

    Points: 510

    ask the deep questions,

    massage the data,

    coax out of it what others can't get to,

    it's my job to know the database structure, where the data are coming from, where they get sent too....

    basically a DBA with a focus on the data visualization.

    I enjoy what I do.

  • The Dixie Flatline

    SSC Guru

    Points: 53253

    I'll bet you do. Sounds like a dream job.

    Thanks for answering, promptly. I was having trouble ceasing to imagine a tiny little couch for bytes.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply