Tag Archives: tsql

SQL Grouping on Sums (with testing)

I ran across a post recently that I thought was an interesting T-SQL problem. The user wanted to group values into a running total, but the groups would reset based on a sum. In this case, the user had this … Continue reading

Posted in Blog | Tagged , , ,

Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve some problems very well, in a way that’s much easier than has been available in T-SQL. However there are some … Continue reading

Posted in Blog | Tagged , | 2 Comments