How do I combine the results of two stored procedures into one dataset?
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.