>When is the best time and conditions to use Views?
Really vague questions. A good use of views is to present a simplified structure to the user or to break down complicated queries into pieces.
>When is the worst examples of using Views inappropriately?
IMHO, updating data through a view.
I'm a BIG fan of all data access going through stored procedures!!
-Mike