• The view is a good approach.

    You could also look to adding an additional join to a table that lists the data you want (or don't want, I'd probably go with whichever is the smaller data set) included and then filter by that table.

    You could also look at an in-line table function that you can pass an exclusion list to (or again, an inclusion list). Not sure I like that idea, but I'm thinking about this as I type.

    "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