Why nested views are not recommended?

[Ford Desperado]

I'm reading a book 'Professional SQL Server 2000 Programming' by Robert
Vieira

there is a recommendation: "stay away from building views based on
views"

Why? What's so wrong with nested views?

[Simon Hayes]

Re: Why nested views are not recommended?


"Ford Desperado" <ford_desperado @yahoo.com> wrote in message
news:1120750476 .256330.212300@ g49g2000cwa.goo glegroups.com.. .[color=blue]
> I'm reading a book 'Professional SQL Server 2000 Programming' by Robert
> Vieira
>
> there is a recommendation: "stay away from building views based on
> views"
>
> Why? What's so wrong with nested views?
>[/color]

http://www.windowsitpro.com/Article/ArticleID/43329/43329.html

Simon

[Ford Desperado]

Re: Why nested views are not recommended?

thanks Simon