Hi Alex,

I've not attempted this with SQL Views, but you could try:

SELECT * INTO YourNewTableName FROM YourExistingViewName

as this will create a table from your view.

If you want, you can get SQL Server Agent to run a job to recreate this table every hour or something with a TSQL statement like:

use YOURDB
truncate table YourNewTableName
SELECT * INTO YourNewTableName FROM YourExistingViewName

if your view is dynamic, replace the truncate with a drop.

HTH

Martin