Focuses on SQL Server, especially T-SQL development and programming, with the aim of presenting projects and problems in SQL Server and the thought process behind delivering a solution.
Thursday, June 18, 2009
Cool Use of CTEs to create number table
Many developers have needed to create a numbers table for matching data to ranges, etc., and this article shows various ways to do it, including multiple uses of CTEs: http://www.projectdmx.com/tsql/tblnumbers.aspx
No comments:
Post a Comment