• I can't honestly say the number of times I've seen this go badly. Views calling other views that are joined to views which contain other nested views... It feels so logical, but it absolutely doesn't work well within SQL Server.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning