I though about recreating the view whenever the company/data changes but this is too much overhead IMHO. Creating a temp database as you suggested would be even more so. Thanks.
>Another option is to create a temp dbc, using CREATE DATABASE, and create the views on the fly for the company you want useing the CREATE SQL VIEW command. Then you could blow away the views and database each time. Might make your application slower depending on how many views you create.
It's "my" world. You're just living in it.