Geeks With Blogs
Thomas Pepe SQL
Using CTE to concatenate rows by group
CTEs or common table expressions can be used to make recursive SQL stantements. CTEs are ANSI-99 standard. Please read www.sql-server-performance.... for more information. I have only had 2 instances in my career where CTEs made sense for me to use in a pratical setting. If you have found them more practical, please share. The first time I needed a CTE I was displaying corporate branches from a recurssive table. Some branches had branches, which had branches, and so on, whereas ......

Posted On Wednesday, July 27, 2011 12:13 PM

Copyright © tom | Powered by: