MS SQL Server MSEQ - prompt for parameter in a view

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

prompt for parameter in a view

Tyler

2005-06-22, 11:23 am

I would like to create a view that will prompt the user for a parameter.
Much the same way a user can provide the paramenter for a query in Access.
Seems like it should be simple, but I don't know how to do it.

Any ideas?

Thanks
--
Tyler

Hari Prasad

2005-06-22, 11:23 am

Hi,

SQL Server will not prompt for a user input. Access will allow because it
have both Front end and back end.

Thanks
Hari
SQL Server MVP

"Tyler" <Tyler@discussions.microsoft.com> wrote in message
news:CA2CA968-4B15-4ED6-AECF- FE3C17C119AB@microso
ft.com...
>I would like to create a view that will prompt the user for a parameter.
> Much the same way a user can provide the paramenter for a query in Access.
> Seems like it should be simple, but I don't know how to do it.
>
> Any ideas?
>
> Thanks
> --
> Tyler

Sponsored Links