Jump to content

Return the same result set twice in stor proc


Guest coreyinkato

Recommended Posts

Guest coreyinkato

I have a unique situation which I need to create a procedure to return a recordset twice. I have the proceedure created & it works fine, returning the values I want however I can't figure out a way to return the same values twice.Without making this too long of a story, I need the records twice to hand off to a Crystal Report that will be set up having 2 of the same item on the page (a 2-up label).I've never had this scenerio before, any advice is appreciated.Thanks! :)

Link to comment
Share on other sites

It is not possible to return a recordset twice if you only run the procedure once.I am not faliliar with Crystal Reports but are you using a programming language to process the recordset? Why not just pass the same recordset twice.Sorry if I don't understand your situation. Can you be more specific?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...