|
Demonstrates how to join results from a Stored Procedure with a normal table output
|
Email
|
| Submitted on: |
4/20/2004 4:39:19 AM |
| By: |
Kazi Khalid
|
| Level: |
Intermediate |
| User Rating: |
By 5 Users |
| Compatibility: |
SQL Server 2000, SQL Server 7.0 |
| Views: |
16126 |
|
(About the author) |
|
|
|
Demonstrates how to join results from a Stored Procedure with a normal table output
|
| |
|
code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
--**************************************
-- Name: Demonstrates how to join results from a Stored Procedure with a normal table output
-- Description:Demonstrates how to join results from a Stored Procedure with a normal table output
-- By: Kazi Khalid
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=830&lngWId=5--for details.--**************************************
--First set the data access option for the server using your SQL Server name (@@SERVERNAME).
exec sp_serveroption 'servername', 'data access', true
--Example:
use pubs
go
create table #tbl1( i int identity)
insert #tbl1 default values
insert #tbl1 default values
go
create proc sproc1
as
SELECT 1 AS id
go
select *
from #tbl1 t1 join openquery([servername], '{call pubs..sproc1}') t2
on t1.i = t2.id
|
|
Other 2 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 4/26/2004 11:01:06 PM: dotNETJunkie
Nice piece of code. Joins such as this come in handy from time to time, especially in reporting situations. I actually wrote a function that used a temp table which was used to join to a table/query in the db for the use of multi-selected user parameter vaues for a report. Good stuff!
(If this comment was disrespectful, please report it.)
|
4/30/2004 12:07:22 AM:
How would this work with a stored procedure that has parameters passed to it?
Passing a string variable that contains the stored procedure with its arguments into the OPENQUERY function doesn't seem to work.
(If this comment was disrespectful, please report it.)
|
7/1/2004 11:45:49 AM:
Is this really a viable solution considering only members of the sysadmin and setupadmin fixed server role can execute sp_serveroption?
(If this comment was disrespectful, please report it.)
|
8/21/2004 10:37:40 AM: treesprite
Hmmm...same as the following submission I think?
http://www.Planet-Source-Code.com/xq/ASP/txtCodeId.111/lngWId.5/qx/vb/scri pts/ShowCode.htm
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
