• A partitioned view might be what you're looking for. Take a look at these links:

    Using Partitioned Views

    Modifying Data in Partitioned Views