SQL Server 7.0 Programming (Wrox) by Vieira states that it is good practice to avoid views based on views, and instead one should try to wrap it all into one large sql statement. Why is that? I have one very complex view that would be pretty simple to build by combining several other views, but fiendishly difficult to create using one sql statement. Can anybody explain why I should try to make it one statement? TIA