Bones of SQL – Grouping By User-Defined Calendar Periods

Question

Bones of SQL – Grouping By User-Defined Calendar Periods

The Dixie Flatline

SSC Guru

Points: 53354
More actions
September 25, 2016 at 9:14 pm

#329974

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

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

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

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: 533 More actions · Answer 2

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: 53354 More actions · Answer 3

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: 12388 More actions · Answer 4

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: 53354 More actions · Answer 5

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: 533 More actions · Answer 6

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: 53354 More actions · Answer 7

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