1. Computing & Technology

Discuss in my forum

Mike Chapple

Linking a Stored Procedure Recordset to a Table

By , About.com GuideSeptember 27, 2009

Follow me on:

In a recent forum message, Raul Lopez wrote:

"I have a recordset returned from a stored procedure. I have a table that I need to link the column of the recordset to a column in the db table. The recordset pulls the prices of the items on an item list. The table has the items as they were sold by the document.

How do I link this? Is it with the "UNION" or "UNION ALL"?

I look at the way the stored procedure was written and, for the life of me, I cannot seem to find where that procedure is pulling the information from. I think this deals a lot with my lack of knowledge."

Do you have any advice for Raul? Interested in solutions to the same problem? Join the discussion in the About Databases forum!
Comments
No comments yet.  Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2012 About.com. All rights reserved.

A part of The New York Times Company.