Andy Mallon needs to create groups of date ranges in T-SQL:

Here’s where my math nerd-iness comes out… There’s a little trick for “bucketizing” numbers (in this case, turning “Months” into “Month Buckets”):

– Take a number

– Divide it by your bucket size

– Round that number down to a whole number–We’ll call this the “divided number”

– Multiply the “divided number” by the bucket size–This is your bucket floor

– Add one to the “divided number” and then multiplythatby your bucket size–This is your bucket ceiling

I was promised that there would be no math.

Comments closed