22,210
社区成员
发帖
与我相关
我的任务
分享
declare @iTotalRPGroup int;
select COUNT(*) from RPGROUPS_RPACCESS
WHERE ROUTEPOINTGROUPID = @RPGroup_ID
GROUP BY routepointgroupid, routepointid;
set @iTotalRPGroup = @@Rowcount
SELECT 'TRUE' AS ISGROUP, NULL AS DESTINATION, DESTINATIONTYPE, NAME_SCENARIO, DESCRIPTION
FROM VIEW_MODEDETAILGROUP
WHERE routepointgroupid = @RPGroup_ID
GROUP BY DESTINATIONTYPE, NAME_SCENARIO, DESCRIPTION
HAVING COUNT(*) > = cast(@iTotalRPGroup as varchar(255))
declare @iTotalRPGroupint;
select @iTotalRPGroup=COUNT(*) from RPGROUPS_RPACCESSWHERE ROUTEPOINTGROUPID=@RPGroup_IDGROUPBY routepointgroupid, routepointid;
declare @iTotalRPGroupint;
select COUNT(*)from RPGROUPS_RPACCESSWHERE ROUTEPOINTGROUPID=@RPGroup_IDGROUPBY routepointgroupid, routepointid;
set @iTotalRPGroup= = @@rowcount
-- 或者, @iTotalRPGroup 获得符合查询条件的行数。。。
declare @iTotalRPGroup int;
select @iTotalRPGroup=COUNT(*) from RPGROUPS_RPACCESS
WHERE ROUTEPOINTGROUPID = @RPGroup_ID
GROUP BY routepointgroupid, routepointid;
-- 不知道你的业务需求,只能试着写一个
-- 这个是 @iTotalRPGroup 获得上条语句影响的行数,按你的原句写的。
declare @iTotalRPGroup int, @c int;
select @c=COUNT(*) from RPGROUPS_RPACCESS
WHERE ROUTEPOINTGROUPID = @RPGroup_ID
GROUP BY routepointgroupid, routepointid;
set @iTotalRPGroup = @@Rowcount