Using SQL Server Views instead of tables

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

Martin,

 Thanks, but unfortunately I need this to work in real-time.  I guess I could create a table instead of the view and drive it from triggers, but that's really ugly and unmaintainable.

I wonder if K2 is coming out with a fix for the SQL Service.

-a