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 |
|
AShehzad
Starting Member
8 Posts |
 Posted - 2008-11-14 : 01:01:19
|
| Is it possible to create a view that will be populated by record set generated by execution of a system stored procedure?Atif Shehzad DBA Pakistan Revenue Automation Limited |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-14 : 01:08:39
|
| Why do you want to do this?MadhivananFailing to plan is Planning to fail |
 |
|
|
AShehzad
Starting Member
8 Posts |
Posted - 2008-11-14 : 01:28:33
|
| For a report application, i have to get table names where foreign key from a table is being used. I have to use sp_fkeys table name. So instead of geting values in a temp table and filtering the required columns from that i want to make a view where i can have values from this sp and i may get required columns from there. If you have any other way to optimize this process then please suggest.Atif Shehzad DBA Pakistan Revenue Automation Limited |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-14 : 02:31:54
|
| Isnt temp table approach better than creating a view? |
|
|
|
|
|
|
view by record set of a system sp