Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Jan 10, 2012 12:51 PM|LINK
what is CTE and what is the advantage. is there any advantage regarding performance of using CTE. it looks it is like temporary view.
WITH MyData AS
select Specialist,jid from bbajobs
select * from MyData
please discuss about CTE in detail