<div>
You can create a trigger on the base table to write to a different table whenever there is data change...<br />
OR <br />
You can use the replication: Replicate a view to a table...<br />

</div>


You can create a trigger on the base table to write to a different table whenever there is data change...
OR
You can use the replication: Replicate a view to a table...


<div>
Is it possible to provide an example - I don't really know sql.
</div>


Is it possible to provide an example - I don't really know sql.

<div>
<div class="content wysiwyg-content">
I have a view that uses random records from another table each time it is used. I need to use this view in a software but the software will only accept tables. I'm trying to get the table to always contain the same data that is in the view and make sure that it also gives new random records whenever shown/refreshed. The fields are Class, Description, Image and Instructions. Thanks in advance.
</div>
</div>


I have a view that uses random records from another table each time it is used. I need to use this view in a software but the software will only accept tables. I'm trying to get the table to always contain the same data that is in the view and make sure that it also gives new random records whenever shown/refreshed. The fields are Class, Description, Image and Instructions. Thanks in advance.

Table that mirrors a view in Sql Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.