views and stored procedures - A CRY FOR HELP! 
Author Message
 views and stored procedures - A CRY FOR HELP!
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



Wed, 18 Aug 2004 20:49:40 GMT
 views and stored procedures - A CRY FOR HELP!

rob,

i'm a bit lost as to what you're trying to do. can you post some sample.

--
-oj
http://rac4sql.home.attbi.com


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



Thu, 19 Aug 2004 04:21:21 GMT
 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



Thu, 19 Aug 2004 07:22:57 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Please help to convert view on views to stored procedure

2. Please help to convert view on views to stored procedure

3. temporary tables in stored procedures/parameter views vs stored procedures

4. Stored procedure dependancy on tables, views and other stored procedures

5. stored procedure for viewing views...

6. Please Help w/ Checking out Stored Procedures from InterDev Data View

7. Help !!Decrypting Stored Procedures and Views

8. Help with stored procedure calling another stored procedure.

9. HELP: Stored procedure calling stored procedure

10. Stored Procedures & Views - where are they stored

11. View what stored procedures are currently in the procedure cache

12. Calling a Java Stored Procedure from another Java Stored Stored Procedure


 
Powered by phpBB® Forum Software