Multiple requests to a view?

[deostroll]

If a view is called multiple times by various applications, how does sqlserver respond? Does it execute the select statement (inside the view) only once or does it execute them per request?

[QPun]

it execute them per request.. :) If you don't mind, on what purpose that make u consider such a question? Performance?

[deostroll]

Me and my friend were discussing whether to go for a view or a stored procedure, because all we needed was an inventory report kind of stuff... I just learned that we further "abstract" from a view whose inside select statement is a kind of general query with no where condition or with some minimal conditions. A stored procedure on the other hand would work faster because we are exacting data we need with more where conditions. In both the cases we are only interested in the result set.