Sorry, no useful code here...just whimsy:

select What, sum([where]) over() 'The Rainbow'

from (

select 'Blue' as What, 1 as [where] UNION

select 'Birds' as What, 1 as [where] UNION

select 'Flyyyyyyy' as...

Hey Michael,

I get that question a lot! 🙂

It definitely is not a common need but one of the things my company supports are compensation plans for direct marketing and multilevel...

Thanks for this article and the original! One question though... have you tried a very deep hierarchy on any of your methods? Like a million node binary tree (not necessarily...

Many accidental DBA's are developers and may be doing both roles.

Technically i'm a Stealth DBA (I do dba things cause we, as a company, need it...even though its not in...

Sure... use as you see fit 😉

Steve,

I just took a shot at rewording a bit. I hope it's helpful even if it's just by taking bits an pieces. If not, feel free to disregard:

Abstract:

Best practices...