CTE In Sql server
what is CTE?what is the Use of it?where we have to use of it.with example.what is advantage of using it.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Riddhi ValechaPosted Aug 11, 2014, 1:17 PM
Refer the links -
http://www.sqlservergeeks.com/articles/sql-server-bi/38/sql-server-%E2%80%93-what-is-common-table-expression-cte
https://www.simple-talk.com/sql/t-sql-programming/sql-server-2005-common-table-expressions/
These links have examples.
It depends, if you want the output as shown in the link, you can use CTE.
Rosi Sreenivasa ReddyPosted Aug 2, 2014, 3:51 AM
Rosi Sreenivasa ReddyPosted Aug 2, 2014, 3:41 AM
Riddhi ValechaPosted Jul 31, 2014, 4:43 AM
---
http://technet.microsoft.com/en-us/library/ms190766%28v=sql.105%29.aspx
http://blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/
Hope these sites help.