Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 question on Stored Procedure

Author  Topic 

brkonthru
Starting Member

31 Posts

Posted - 2001-06-12 : 04:51:17
I have a quite complex select statement that takes a long time to execute. From my limited reading, I understood that a Stored Procedure would make the execution of this select statement quite quicker.

How do I create simple stored procedure that has a select statement and takes a variable or two for the 'where' part of the select statement?

I tried using the SP wizard in SQL2K, but it only had things for insert/update/delete, i'm not even sure that a select statement is at all possible with an SP

I would appreciate any pointters, thanks

   

- Advertisement -