Donner's Daily Dose of Drama
Ethics, technology, and everything in between.
  • The Good
    • Blogging
    • Consumer Protection
    • Environment
    • Ethics
    • Geek’s Home
    • Lisa Lanett
    • Medfield
    • Music
    • Parenting and Technology
    • Travel
    • wow
  • The Bad
    • Business
    • Ebay
    • Investment
    • Job search
    • Personal Finance
    • Politics
  • The Ugly
    • Information Technology
      • Business Intelligence
      • Content Management
      • Free Software
      • I18N and L10N
      • Java
      • Open Source
      • Mobile Devices
      • Open Source Business Intelligence
      • OSBI
      • SDA
      • Security
      • Smartphone
      • Software Best Practices
      • Software Engineering
      • SQL Server
      • Streaming Media
      • Web
    • Austria
    • Fiction
    • Hardware
    • iPod
    • Miscellaneous
    • Uncategorized
    • Video
    • Weekend Warrior
  • Boston
  • About
    • Publications
    • Awards
    • Contact Christian Donner
    • Project Portfolio
    • Speaking Engagements

Participate

  • Log in
  • Entries RSS
  • Comments RSS

Recent Comments

  • Pat on Honda Accord 2003 EX-V6 Transmission Failure
  • Sebastien Cadieux on Honda Accord 2003 EX-V6 Transmission Failure
  • Imran on Honda Accord 2003 EX-V6 Transmission Failure
  • BrandonF on Honda Accord 2003 EX-V6 Transmission Failure
  • Tom on Honda Accord 2003 EX-V6 Transmission Failure
Home   /   SQL
Combining contiguous date ranges in a SQL query – using CTE recursion

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

November 6, 2008
by Christian Donner
SQL Server

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,…

Read Article →
SQL Server 2005 – Recursion

SQL Server 2005 – Recursion

May 3, 2008
by Christian Donner
SQL Server

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)?…

Read Article →
Using SQL Server Column Aliases

Using SQL Server Column Aliases

March 14, 2008
by Christian Donner
SQL Server

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…

Read Article →

Copyright © 2013 Donner's Daily Dose of Drama

Powered by WordPress and Oxygen