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 |
|
Kurmanc
Yak Posting Veteran
92 Posts |
 Posted - 2007-12-11 : 10:21:26
|
| Hi,Is it possible to send more than one value/parameter to a procedure? How is that done?What I mean is,this is possible:EXEC [spTEST] 1, 'spMyProcedure', 20, 'message'but not this:EXEC [spTEST] SELECT id, 'spMyProcedure', age, @report FROM #temptestRegards |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-11 : 10:23:14
|
You have to loop the result and send on line of values (a record) at a time to the spTEST stored procedure.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Kurmanc
Yak Posting Veteran
92 Posts |
Posted - 2007-12-11 : 10:24:12
|
| Yes, I was afraid so..Thanks. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-11 : 10:24:58
|
| well... you could hack something up with sp_MSForEachTable but that's an unsupported sproc..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Kurmanc
Yak Posting Veteran
92 Posts |
Posted - 2007-12-11 : 10:30:55
|
| Thanks for your replies, I'll check your posted links. |
|
|
|
|
|
|
Exec procedure with select statement