Posts Tagged "SQL"

Combining contiguous date ranges in a SQL query – using CTE recursion

Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows into one….

SQL Server 2005 – Recursion

Why do I find all the examples of how to use recursion in SQL Server 2005 too…

Using SQL Server Column Aliases

When you have query that does complex calculations, maybe even has function calls in the select list…