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 |
|
danasegarane76
Posting Yak Master
242 Posts |
 Posted - 2007-03-20 : 00:18:33
|
| Dear All, I am executing a stored procedure [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80798[/url].In this,Now I am facing one problem.When I execute the sp using one varriable like sp_GetFilelist 1 ,it is working .But Now I want to call the sp with more than one arguments like'1','2'.But I am getting an error that so many arguments.How can I solve this problem |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-20 : 01:45:50
|
| When you the procedure accepts only one procedure you can't pass more than one...You have to execute your procedure twice once or you change your procedure to accept the comma delimited string, parse and execute...MohammedU |
 |
|
|
danasegarane76
Posting Yak Master
242 Posts |
Posted - 2007-03-20 : 01:49:15
|
| Dear Mohammaded, Can we split the inputstring inside sql |
|
|
|
danasegarane76
Posting Yak Master
242 Posts |
Posted - 2007-03-20 : 05:30:39
|
| Any replies? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Error in Executing Stored Procedure