Posted by Tony Rogerson on 04/03/06 19:08

> There are no problems with nesed VIEWs and in fact, you can do some
> neat tricks using the WITH CHECK OPTION at various levels of the
> nesting.
>
So you have never tried to diagnose performance or bugs in code developed by
a third party using nested views then?

Nested views are a maintanence nightmare and should be avoided at all cost.

> The real trick is to make sure that the VIEWs have sensible names and
> meanings.

The real trick is to think through what you are trying to do and design your
schema properly in the first place.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1144051881.283954.296270@v46g2000cwv.googlegroups.com...
> There are no problems with nesed VIEWs and in fact, you can do some
> neat tricks using the WITH CHECK OPTION at various levels of the
> nesting.
>
> The real trick is to make sure that the VIEWs have sensible names and
> meanings.
>

[Back to original message]