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 |
|
mavershang
Posting Yak Master
111 Posts |
 Posted - 2009-12-11 : 19:22:54
|
| Hi. I am a rookie. I have a stored procedure which takes 2 input params, do some calculation and use a output param to return the value. But how can I use this procedure as a function to do this:select id1, id2, (exec sp_a id1,id2,@out) as 'value'from tableThanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-12-12 : 01:03:39
|
| see scalar user defined function given herehttp://www.sqlteam.com/article/user-defined-functions |
 |
|
|
|
|
|
select the return value from stored procedure