Yea I was thinking of doing a job to populate the table from the view but was hoping there might be a cleaner way as the time interval needs to...

I have a view of a number of tables in a database (DB1) that gives the following fields for e.g.

Code,GroupID, Name, Location

The results of this view is then used to...