• You can replicate views to table...

    or you can use a query too to replicate to table...

    Check the BOL topic "Publishing Data and Database Objects " and "Filtering Published Data"

     

     

    MohammedU
    Microsoft SQL Server MVP