views and stored procedures - A CRY FOR HELP!
Yes, you can create a stored procedure with input parameters and
inside the stored procedure have a SELECT statement that selects from
a view, if that is what you're asking. However, for SQLS 2000 you
might want to investigate using inline user-defined functions, which
are like view except that they also support input parameters. See BOL
for details or post back more specific information on what you're
trying to do.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
Quote:
>Hi
>Does anyone know if it is possible to create a stored procedure under SQL
>Server 2000, with both input and parameters upon a view that have created
>from my db tables?
>Is this possible - any help would be greatfully appreciated.
>Thanks
