Roland Alexander STL (10/2/2012)
norbert.manyi (10/2/2012)
Take the following example:
select * from tbl_Users U where U.active = 1 and U.deleted = 0
How is the application owner changing the business logic? Is the business changing their procedures? Or is more a case of changing SARG values? A little more detail's needed, I think, before we can begin to answer.
For the previous example, we had to add a TempInactive field, so employees on maternal/paternal leave can be excluded. Also business decided (against my insistencies) that deleted employee records are no longer kept, so the deleted field became obsolete.
But I got a better example in the following post.