Table that mirrors a view in Sql Server 2005

Posted on 2008-11-17
Last Modified: 2012-05-05
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.
Question by:dynamk
    LVL 15

    Expert Comment

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

    Author Comment

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

    Accepted Solution

    Check the following link...

    For is going to be big script...but you can try using SSMS...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now