After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality. … Read more
The SQL Server common table expression was introduced into standard T-SQL to simplify queries for which a derived table just wasn't suitable. Robert Sheldon explains CTEs in this article.… Read more