All Tags »
BlackPearl »
SmartObject »
SQL Server (RSS)
Sorry, but there are no more tags available to filter with.
-
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 ...