norbert.manyi (10/2/2012)

---

Take the following example:

select * from tbl_Users U where U.active = 1 and U.deleted = 0

It seems that the application owner keeps changing the business logic, so I would like some opinions on how I can make the business logic as separated from the code as possible.

My first idea (given my coding background) was to create functions to be used like

select * from tbl_Users U where fn_IsUserActive(U.UserID) = 0 but I don't know about how much that would degrade performance...

Ps. I understand that this particular example can be done using views, but I'm taking about the situations where you cannot do this. (I just can't find a good example right now)