All Tags »
blackpearl »
SQL Server »
SmartObject (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 ...