Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 30, 2012 09:38 PM by imobsuz
Member
84 Points
80 Posts
Dec 30, 2012 07:07 PM|LINK
Hello,
I want to know about CTE ,how it works, how to use it and when to use it.Can any one suggest me any article on this
Contributor
3970 Points
1096 Posts
Dec 30, 2012 09:06 PM|LINK
Your google search string is "sql server with statement".
To me, it's another way of writing a subquery. If you are going to use the same subquery more than once, it should run faster with the "with keyword" because the subquery only executes once.
Participant
1278 Points
195 Posts
Dec 30, 2012 09:38 PM|LINK
Hi,
Check the articles below:
http://msdn.microsoft.com/en-us/library/ms190766.aspx http://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER-2008
Hope this helps.
amithashenoy
Member
84 Points
80 Posts
CTE
Dec 30, 2012 07:07 PM|LINK
Hello,
I want to know about CTE ,how it works, how to use it and when to use it.Can any one suggest me any article on this
All the Best . Please 'Mark this Post as Answer ' if it helps you.
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: CTE
Dec 30, 2012 09:06 PM|LINK
Your google search string is "sql server with statement".
To me, it's another way of writing a subquery. If you are going to use the same subquery more than once, it should run faster with the "with keyword" because the subquery only executes once.
imobsuz
Participant
1278 Points
195 Posts
Re: CTE
Dec 30, 2012 09:38 PM|LINK
Hi,
Check the articles below:
http://msdn.microsoft.com/en-us/library/ms190766.aspx
http://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER-2008
Hope this helps.