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 |
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
 Posted - 2010-07-30 : 01:12:32
|
| i have a SP for counterID generation and i want to use this SP in another SP and this is want to achive by storing the SP generated value in another variable.i m doing : declare @a varcharset @a=exec SPcounterbut this is giving error.scoo |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-07-30 : 02:41:42
|
| Return:-exec @a=SPcounterSelect @aResult Set:-Insert into #temp (col1 int)exec SPcounterSelect * from #temp Output variable:-EXEC SPcounter @a OUTPUTSelect @aSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
|
|
|
storing store procedure value in anther variable