如何在asp.net中合并两个存储过程并在Crystal报表中显示 [英] How to Merge Two Stored Procedure in asp.net and Display in Crystal reports

问题描述

尊敬的先生，

如何在asp.net中合并两个单独的存储过程，并在Crystal报表中显示.

例如，


sp_RestTbl1和
sp_OrderTbl1

这2个存储过程如何加入/合并
并显示在网页中.

通过mohan

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

推荐答案

，您可以在该proc内另外创建一个名为proc3的存储proc

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

create or alter procedure proc3
begin

exec proc1 param1, param2
exec proc2 param3, param4

end

这是一个粗略的想法，proc3将在两个不同的结果集中同时从proc中提供合并的结果.

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

如果您可以访问两个存储过程的源，则复制并粘贴两个源将其存储到一个新的存储过程中，并在两个部分之间放置一个UNION 关键字以将它们合并并对其进行单个存储过程.
我认为其他方法也很粗糙.

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.

这篇关于如何在asp.net中合并两个存储过程并在Crystal报表中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！