Common Table Expression(CTE) in SQL Server

Sign in to leave a comment.

• RM

  Ramzanali Momin8y agoPosted Aug 27, 2018, 12:41 AM

  Nice article !
• VD

  Vijayabhaskar Dabbara11y agoPosted Feb 25, 2015, 3:16 AM

  where does it store's the CTE in SQLSERVER DB's memory-Exactly..............!
• MP

  mohit porwal13y agoPosted Oct 11, 2013, 2:12 AM

  Thankssss
• AP

  Amit Pathak15y agoPosted Sep 2, 2011, 4:45 AM

  Hi, I appreciate ur post.but i have some doubt as per ur post u have considered CTE as storage object such TEMP table or Table variable. look at the following code WITH cteMYCTE as ( SELECT t2.id FROM table3 t3 INNER JOIN table2 t2 ON t2.id=t3.ID ) SELECT * FROM cteMYCTE cm DELETE FROM Table3 WHERE id=3 DELETE FROM Table2 WHERE id=3 SELECT * FROM cteMYCTE cm this query gives error while it executes the last select query..... this means cte doesnt retain records fetched by it in last time. i think you cant say it a storage object like temp table or table variable......
• N

  niv15y agoeditedPosted Apr 7, 2011, 9:00 AMEdited Apr 7, 2011, 9:31 AM

  I have a table employee with dept no and salary, i need to find 2nd highest salary for each dept. plz help. mail if poss on [email protected]
• SL

  SQL lion16y agoPosted Aug 17, 2010, 2:05 AM

  CTEs(Common Table Expressions) are one of the beautiful and the most powerful feature of SQL Server and are boon to SQL Server developers. These not only simplifies most of the complex operations in T-SQL but also do a lot more than one can imagine. Follow the link to know the details…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> http://www.sqllion.com/2010/08<WBR>/common-table-expressions-cte/<o:p></o:p>
• YP

  yakoob pasha16y agoPosted Jul 29, 2010, 9:40 AM

  yeah it's simple and easy to understand thanks a lot...
• NM

  Nagul meera16y agoeditedPosted Jul 8, 2010, 1:13 AMEdited Jul 8, 2010, 1:14 AM

  It's very nice and easy to understand.keep it up Thank u
• RV

  Raghavanantham Venkatesan16y agoPosted Jun 22, 2010, 7:09 AM

  very nice tutorial for increasing database performance
• CJ

  clive jensen16y agoPosted Dec 3, 2009, 3:39 PM

  Hi Erode, I liked your examples on CTE. I need to replace plenty of my stored procedures that use cursors with something else to improve query speed, I am considering CTE's. Can you give examples of converting cursor stored procedures to CTE stored procedures. [email protected]
• EE

  egre erer17y agoPosted Nov 30, 2009, 1:15 AM

  hi
• SP

  srinivasulu P17y agoPosted Nov 11, 2009, 6:31 AM

  NICE START MATERIAL.