http://www.sqlmag.com/authors/author/author/5038351/rss/5038351en-USFri, 25 May 2012 10:28:22 GMTFri, 25 May 2012 10:28:22 GMThttp://www.sqlmag.com/article/tsql3/aggregating-time-series-dataWith this T-SQL algorithm, you can consolidate chains of related date intervals, maintaining lapses in the dates, without using iteration or cursors.]]>Michael ArneyFri, 01 Feb 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/aggregating-time-series-datahttp://www.sqlmag.com/article/tsql3/grouping-web-site-hits-into-sessionsUse these techniques to calculate the effectiveness of your Web site.]]>Michael ArneyFri, 01 Feb 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/grouping-web-site-hits-into-sessions