Geeks With Blogs


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:

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: