>Hi Kevin,
>I think you caught my misunderstanding of the views. I should have said that I am looking for a way to extract the data into a view daily. But since I posted my questions and based on the input and/or questions of others, I see that I could do what I need right from the data table, without a view. I am working on testing my "approach".

OK....Actually, Craig's response is ideally the best approach. A basic SSIS package that writes out data with a specific output name as a job. Yes, I realize there's a learning curve, but SSIS is such a powerful tool that it's often worth the learning curve.