[font="Verdana"]
Hugo Kornelis (4/21/2010)
Good, clean question, Ron. Nice work!abrar.ahmad-1058946 (4/21/2010)
I conceived your quest statement as 'The Single Defining Select Statement of View Definition' as shown in code segment 1 above.The question explicitly states: "Can a View be created using a CTE as part of its defining SELECT statement.?" The emphasized part makes it very clear that the question was not about creating a view using only a CTE as its definining SELECT statement.
following seems cool to me
Do body of a view can contain CTE/s?
Do we can use CTEs within a view defintion?
But i appreciate your "emphasized part" understanding, and would try to correct myself in future.
Thanks buddy.
[/font]