How to Merge Two Stored Procedure in asp.net and Display in Crystal reports

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Dear sir,

How to Merge Two separate Stored Procedure in asp.net and Display in Crystal reports.

For Example,

sp_RestTbl1, and
sp_OrderTbl1

these 2 stored Procedure how to join/merge
and display in webpage.

by mohan

Posted 1-Nov-11 1:01am

Mohankumar.Engain

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pandya Anil · Answer 1 · 2011-11-01T02:00:00

Solution 1

you can create one more store proc named proc3, inside that proc

SQL

create or alter procedure proc3
begin

exec proc1 param1, param2
exec proc2 param3, param4

end

this is a rough idea, the proc3 will give ceombined result from both the proc, in 2 diffrent result sets.

Posted 1-Nov-11 2:00am

Pandya Anil

Comments

Mohankumar.Engain 1-Nov-11 9:17am

ok its good idea....
but second execute statement is does not affect in binding the crystal reports(not display in report).
any idea for this error.
only first statement only displayed. why like that display any idea....
by mohan...

Mohankumar.Engain 1-Nov-11 9:19am

I mean second statement column does not display, field Explorer (Crystal report viewer)in select report source time....

Amir Mahfoozi · Answer 2 · 2011-11-02T00:04:00

Solution 2

If you have access to the source of the two storedprocedures then copy and paste two sources into one new stored procedure and put a UNION keyword between the two parts to merge them and make a single stored procedure of them.
I think other ways are as rough as this one.

Posted 2-Nov-11 0:04am

Amir Mahfoozi