Geeks With Blogs

News

View Anthony Trudeau's profile on LinkedIn

Add to Technorati Favorites


Anthony Trudeau

One of the uses mentioned for common table expressions (CTE) in SQL Server 2005 is recursive queries.  A CTE allows you to define a virtual view that can be used in another statement.  At first glance I thought this was awesome.  In fact I had just recently implemented a user-defined function to calculate the “pieces per” based on a global trade item number (GTIN), because recursion is necessary to calculate the value.

The following article has more information: http://geekswithblogs.net/tonyt/articles/70279.aspx

Posted on Thursday, December 29, 2005 3:12 PM | Back to top


Comments on this post: Notes on using a CTE in SQL Server 2005

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Anthony Trudeau | Powered by: GeeksWithBlogs.net