Solved

How do I combine the results of two stored procedures into one dataset?

Posted on 2010-08-25
5
461 Views
Last Modified: 2012-05-10
I have two stored procedures.  One (usp_Products) results in a distinct list of products my company sells.  The other (usp_DocType) results in a distnict list of document types we provide.  I want to combine these so that I get one dataset with both.  Example below.

Products                        DocumentTypes
A                                             1
B                                             2
C                                             3


0
Comment
Question by:NevSoFly
5 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 500 total points
ID: 33525035
CREATE TABLE #Product
(
   ID INT IDENTITY(1,1),
   Product VARCHAR(MAX)
)

CREATE TABLE #DocumentType
(
   ID INT IDENTITY(1,1),
   DocumentType INT
)

INSERT #Product (Product) EXEC usp_Products
INSERT #DocumentType (DocumentType) EXEC usp_DocType

SELECT
 p.Product AS Products,
 d.DocumentType AS DocumentTypes
FROM
 #Product p
FULL JOIN
 #Document d
ON
 p.ID = d.ID
0
 
LVL 16

Expert Comment

by:Sheils
ID: 33525039
Can you provide the codes for the stored procedures
0
 
LVL 5

Expert Comment

by:jijeesh
ID: 33525150
If you just call both SP in an another single SP, the result will apprear in a single data set, but in difeerent DataTables.
0
 
LVL 8

Expert Comment

by:mustaccio
ID: 33525275
How do you know that the document type 1 corresponds to the product A etc.?

0
 

Author Closing Comment

by:NevSoFly
ID: 33527089
Thanks to all for your help.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now