Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-11-27 : 07:53:10
|
| I've inherent this project which has multiple views and sub views, most of the views/subviews are based on a raw data extract. For example i have the raw table extract were a view is created from it to pick certain data from , then the view would rejoin with the raw table again to create another view...to give the final dataset which is use in the over all view results.Am still making my way through all these sub views and going back another level to the first view that builds these up. What i would like to know is how should i approach the redesgin. Am thinking of using stored procedures build into a DTS package to do the same work as the view would do and then transform the final data set results colums to a final table. Any help would be appreciated |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-27 : 08:34:11
|
| We can't hekp unless we know what you are trying to do.You haven't explained why you are working on this. Is something not working?CODO ERGO SUM |
 |
|
|
|
|
|
ReDesgin of views to ...