Joining on an SP - Potential Solution

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Joining on an SP - Potential Solution

Author

Topic

sureshot
Yak Posting Veteran

72 Posts

Posted - 2005-03-11 : 03:02:14

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03e9.asp

Interesting article. I've actually tried it and it works great for stuff like sp_who using a self referencing linked server.

I never saw part 2. Any ideas on how to address the issues with this technique for problem SP's that cannot have columns determined? (sp_who2 was given as an example).

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-03-11 : 07:58:17

Nothing wrong with writing a version of a stored procedure that does the joins you want. Then you don't even need to use linked servers to get around it.

sureshot
Yak Posting Veteran

72 Posts

Posted - 2005-03-11 : 16:20:56

I thought it might be a nice solution to keep things nice and maintainable without lots of derivative SP's with similar code.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources