Posted by --CELKO-- on 10/01/98 11:42

>> is there anyway I can consolidate all these views into one? <<

Sure, but why? You can nest VIEWs without any problems. Those other
views were probably constructed for a good reason. "Trust in the
Optimizer, Luke!"

However, look up the WITH CHECK OPTION on VIEWs; could be useful.

• Next in forum: Re: Getting list of recently added IDENTITY items
• Prev in forum: Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join
• Thread view: Re: views dependent on other views

[Reply to this message]