Greetings,I've used "WHERE 1=1" for a long time in dynamic where clauses in which every condition is optional, and lately I heard it suggested that this can cause full table scans by itself. From ...

It is generally better in SQL. From looking at what you're doing, it looks like you may need an "active" column - where are you storing whether a field is active?