34,593
社区成员
发帖
与我相关
我的任务
分享
Create PROCEDURE [dbo].[esp_ListProjectStatistics]
@PeopleID as varchar(50)
AS
BEGIN
Declare @iParticipate int
Declare @iFavorite int
--我参与的工程项目
create table #1(......)
insert into #1 exec esp_ListParticipateProject @PeopleID
Set @iParticipate = @@Rowcount
--我关心的工程项目
create table #2(......)
insert into #2 exec esp_ListFavoriteProject @PeopleID
Set @iFavorite = @@Rowcount
Select @iParticipate as ParticipateNum,@iFavorite as FavoriteNum
END