Feedback on CTEs

Hot Topic

Authentication, windows or custom
Upsizing Access 2003 database to SQL Server Express
Random access in a result set
.NET2 SMO Components
Instantiating ReportExecution2005 fails with forms authentication
SQLPrepare and SQLExecute returns Permission Denied in SQL 2005
Hundreds Of VIEWS
Report Builder Color Pallette
SETISOLATION_FAILED Question
Unable to use Books Online search function

SQL Server

unable to load SQLBOOT.DLL
Beginner question Searching table
How can I convert download SQL Server 2005 to a licensed version.
Separate date and time datatypes - come on guys!
2005 encryption - symmetric keys
Install server2005 in LDAP machine problem
how to write 55.5 into sql2000 via OLEDB ?
Shredding recordset object var in ForEach loop (problem)
Decimal problem with expression
Result of FOR XML into variable

Feedback on CTEs

When I first saw this feature I though "Yeah, that's a nice-to-have"

Now that I'm actually using them for real my opinion has changed to "WOW. These solve SO many problems that I couldn't have solved otherwise". Specifically I'm using them to navigate hierarchies (which is of course what they are for).

Kudos to the SQL Server team, and thanks very much!!

-Jamie




Answer this question

Feedback on CTEs

  • Wheat

    Add me to the List ;)

    This saves me from writing my own set based hierarcy functions...

    I am just wondering about one point...

    What happens if i have a CTE that adds a "Rownumber" to a querry (for paging). and a user requets rows 500-600

    Will the CTE evaluate ALL rows or will it stop after it reached row 600
    And what if we have a computed column in that table Will it be evaluated for rows 1-499

  • FSales

    Thanks for your feedback. Happy to see that you like the feature and it does help solve lot of problems using a set-based logic. I will pass it on to the team.

  • Feedback on CTEs
Answer this question