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 |
|
irish_ciaran
Starting Member
1 Post |
 Posted - 2010-03-30 : 05:49:20
|
| Hi guys!Just a quick question, I would like to create a report in (SQL Report Builder 2008 2.0) which when opened will prompt the user to select a specific date via a combo box or text box and when selected will then display the information of that specifc record in the report below along with the other additional data from the other fields, Is there any way in which I can create s stored proceedure that will permit me to select between dates in a query in SQL. Im assuming it may be something like the below....Create procedure spStartDateas select * from tblNorthwindwhere StartDate =exec spStartDateRegards |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-30 : 07:58:37
|
No.T-SQL and stored procedures are running on the server and have no dialogs.You only can give parameters when calling it.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Stored Procedures