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.
| 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 SPI would appreciate any pointters, thanks |
|
|
|
|
|