如何对SQL Server中动态数量的组进行值分组

I've read many/most of the posts regarding grouping in ranges but none seems to cover my dilemma, to group date according to a dynamic range of values, so I'm hoping someone can help or at least point me in the right direction.I've read many/most of the posts regarding grou