• Here's what BOL says about CTE's (not at either link you posted, but rather here: http://msdn2.microsoft.com/en-us/library/ms175972.aspx)

    "Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, or DELETE statement. This clause can also be used in a CREATE VIEW statement as part of its defining SELECT statement. A common table expression can include references to itself. This is referred to as a recursive common table expression."

    Here's what the author said (http://www.sqlservercentral.com/columnists/sramakrishnan/2734.asp):

    "Common Table Expressions : Common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. Unlike a derived query that was commonly used in SQL 2000, you dont need to copy the query definition multiple times each time it is used. You can also use local variables within a CTE definitionsomething you cant do in a view definition."

    Basically the sentence fragment "defined within the execution scope of a single SELECT, INSERT, UPDATE, [or] DELETE" looks to be the same on this one. The reference the author posted to BOL at http://msdn2.microsoft.com/en-gb/library/ms190766.aspx has this to say:

    "A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query."

    Looks like a chunk of text was lifted word-for-word from BOL in this instance.  I'm not going to personally compare the whole article to BOL, but the author should have definitely used parenthetical and in-text citations, or footnotes, so that readers could tell exactly what was being quoted from BOL versus his original work.

    To the author, here's what it might look like with a proper citation:

    Common Table Expressions : Books Online provides this definition of a Common Table Expression: "Common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement." (http://msdn2.microsoft.com/en-gb/library/ms190766.aspx). Unlike a derived query that was commonly used in SQL 2000, you dont need to copy the query definition multiple times each time it is used. You can also use local variables within a CTE definitionsomething you cant do in a view definition."

    It's OK to quote from other sources, but you have to properly cite the sources.  Properly quoting and citing authoritative sources on a topic does not detract from your original work, but not properly citing sources makes all your work suspect.  Someone should write an article on that...