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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-11-10 : 08:02:57
|
| After executing the SP ( exec sp_name ) i am getting 100 records.I dont have table create permission , just output data of SP shud be joined with another table , so my sp output shud be act as table to make join. How to act? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-10 : 08:18:57
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/26/select-columns-from-exec-procedure-name-is-this-possible.aspxMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Ouput of SP shud be use in select statement