Combining 2 Stored Procedures into 1 1

[solla]

I have inherited 2 stored procedures from an Access database:

=====SP1
SELECT [ID]
FROM SP2
WHERE (GC=reqGC) And (UC=reqUC);

=====SP2
SELECT [ID], Count([GroupID]) AS GC, Count([UserID]) AS UC
FROM TABLE1
GROUP BY [ID];

Note that SP1 calls SP2.

I am struggling to translate this logic into an SQL Server stored procedure.

Can anyone help me?

 

[swampBoogie]

create procedyre sb_2 (@regCC int, @regUC int)
as
select ID from table1
group by ID
having count(GroupId) = @regCC
and count(UserID) = @regUC