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
Author
Message
Posted Friday, January 31, 2014 9:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:49 AM
Points: 163, Visits: 831
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.

Cheers,


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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:12 PM
Points: 13,441, Visits: 12,303
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 http://www.sqlservercentral.com/articles/Best+Practices/61537/ 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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 6,256, Visits: 7,438
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