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 |
|
benramz
Starting Member
6 Posts |
 Posted - 2011-01-17 : 16:30:29
|
| I am working with a program that contains a number of encrypted stored procedures (Off the shelf). I would like to know if it is possible to execute a stored proc from inside a select statement dynamically.example: Store proc "Foo" returns DueAmtA, DaystilDue, DueAmtB when executed. execution is "Exec Foo <CustomerID>"Select CustomerID, customername, customer address, (Exec Foo CustomerID) from Customer where customerid = 1234 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
benramz
Starting Member
6 Posts |
Posted - 2011-01-17 : 16:55:01
|
| Is it possible to wrap that with a cursor to get the data for all customerid's |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Extracting Stored Proc Data Dynamically