creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgs
You can create a table function to simulate a parameterized view. See "create
function" in BOL.
AMB
"maxzsim" wrote:

> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as part
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgs

creating view as a parameter query

Hi,
I created a view in EM and when i right-click to go to the query designer
it allows me to set some parameter but i seem not able to save this as part
of a view ?
how can i do that or is there other alternatives ?
tks & rdgsYou can create a table function to simulate a parameterized view. See "creat
e
function" in BOL.
AMB
"maxzsim" wrote:

> Hi,
> I created a view in EM and when i right-click to go to the query designer
> it allows me to set some parameter but i seem not able to save this as par
t
> of a view ?
> how can i do that or is there other alternatives ?
> tks & rdgs