Thomas Steinmaurer wrote:

>>Very basic SQL question, sorry for that, but can i pass a parameter to a
>>view?
>>
>>
>
>Only in a regular SELECT statement when querying
>the view, as you do it with tables when using a
>parametrized query.
>
>Views don't support input parameters like stored
>procedures do.
>
>
>

Thanks for you quickly help. I lost something using SP? I mind, using SP
i get all the advantages of using a view like precompiler optimizations
of the query ionside the SP?

TIA.

German.