Once a view is created, which can be created dynamically in a Stored Procedure, It can be used to join to other Views and tables.

I don't see the advantages of your method. Perhaps you can state the specific uses of this methods and its advantages over other ways of accessing data.