• Your Idea looks pretty good, if we are dealing small amount of data.

    in case, if the data grows larger, the performace going to get a hit.

    why i am saying this is, we can't index the views, like you siad in your examples. since it requires schema binding. so Querying or any DML statments on the view that is created from other database tables will be much slower.

    i hope that i make sence

     

    ramesh