January 4, 2007 at 3:21 pm
I've heard that CTE's can help break up a complex SELECT statement into something more manageable. How is this accomplished in Sql Server 2000? Right now I have one view that works fine and then I call that view from within another view. This doesn't seem very efficient, is there a better way?
vwOne: "SELECT blah blah FROM myTable"
vwTwo: "SELECT blah FROM vwOne"
Thoughts?
January 4, 2007 at 11:17 pm
CTE = Common Table Expression.
There is no equivalent functionality in SQL 2000. If you post the actual view statements, maybe we can help.
January 5, 2007 at 2:48 am
It's not uncommon that a view works fine, but when you stack views on top of each other, you may get poorer performance than when using those views separately.
It's one of those things 'how things work'.
It all depends on what the particular view look like...
/Kenneth
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply