The March/April 2006 edition of SQL Server Standard magazine is now

available. This issue focuses on Transact-SQL for SQL Server 2005.

Though I normally focus on the security side of things, I was able to

get an article in on Common Table Expressions and Recursion. I used an

example from an old intranet web application I had developed in the

days before document management systems like SharePoint and others

became available, back in 2000. I still remember deploying the

application to NT 4.0 systems running IIS 4.0 and SQL Server 7.0. That

seems like ages ago giving how both IIS, Microsoft web development

technologies, and SQL Server have developed over the years. Having the

use of CTEs and recursion back then would have simplified some of the

coding but it wasn't available back then.

If you're interested in taking a look at the contents of the most

recent issue of SQL Server Standard magazine, you can find that

information at the following link:  http://www.sqlserverstandard.com/issue/.

It's also where you can order an electronic copy of the magazine. If

you want to subscribe to the magazine, the following link gets you to

that information: http://www.sqlserverstandard.com/subscribe/. If you're an MCP and have registered on Microsoft's MCP Member Site, you can download issues for free from the Special Offers & Events link.