Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows into one….
Why do I find all the examples of how to use recursion in SQL Server 2005 too…
When you have query that does complex calculations, maybe even has function calls in the select list…