The idea is this happens automatically. How do I run this script on a schedule?

I have the perm table, the problem is how to update it without deleting it. right now i have:

CREATE TRIGGER updateTable ON [dbo].[rlvntdata]

FOR INSERT, UPDATE

AS

select * into temp from...

There's a wierd table setup where the rows are in a way acting as columns also... a 3 dimensional table I guess (I didn't create it and don't have the def)....

Here's the view. The problem is there is a web client that need this search to perform <1 sec (which it does when searching on the actual table), and currently...

OK I like that solution - so just create a trigger to do this at some interval?

Forgive my ignorance of SQL Server, but is there a way to just update...

That sounds like a good idea I hadn't thought of. What about running a 'select *' with no where clause on the view and shoving that into an actual table...