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!!
-JamieThanks 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.|||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?
No comments:
Post a Comment