Sometimes we need to reduce the granularity of date ranges by combining serveral contiguous rows into one. While this is a common classic SQL problem,…
Why do I find all the examples of how to use recursion in SQL Server 2005 too complicated (including the one in the Microsoft help)?…
When you have a query that does complex calculations, maybe even has function calls in the select list select costly_function_A() as result_A, costly_function_B() as result_B…
Recent Comments