Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Getting rid of "Nested" views Expand / Collapse
Posted Friday, January 31, 2014 9:24 AM


Group: General Forum Members
Last Login: Monday, February 9, 2015 5:58 AM
Points: 175, Visits: 916
Hi all,

Will be taking over some systems that use these, and wondered if there are any best practice checklists to rewriting these, preferably in '08 version.


Post #1536843
Posted Friday, January 31, 2014 9:44 AM



Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 14,768, Visits: 14,576
Research, analysis, testing.

There is no "easy" way to do this and each one requires a unique process to remove it. They just have to be dealt with one at a time.


Need help? Help us help you.

Read the article at for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1536867
Posted Friday, January 31, 2014 1:49 PM



Group: General Forum Members
Last Login: Wednesday, September 23, 2015 3:34 PM
Points: 5,467, Visits: 7,660
Agreed. There's just too many variables. Example: I personally only usually use views to consolidate a standard approach to get a particular component of data in an optimal way.

IE: I need everyone with Medicare payments in the last 30 days.

If there's a few dozen views that lean on that single point of logic organization, do you really want to un-nest them?

You have to approach them like any other piece of code. Individually research the effects of removing the nesting and look for code re-usage possibilities that are being leveraged that you're about to destroy and up your maintenance.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1536966
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse