Combining Stored Procedures?

From: Noel <vbgooglegroups_at_yahoo.com>
Date: 7 Jul 2005 04:55:42 -0700
Message-ID: <1120737342.009643.285680@g49g2000cwa.googlegroups.com>

I have two stored procedures

ALTER PROCEDURE dbo.qryCountOne
(@inputID int)

AS SELECT COUNT(*) AS CountOne FROM dbo.TableOne WHERE
(dbo.TableOne.value = @inputID)

ALTER PROCEDURE dbo.qryCountTwo
(@inputID int)

AS SELECT COUNT(*) AS CountTwo FROM dbo.TableTwo WHERE
(dbo.TableTwo.value = @inputID)

What would be the best way to combine these two, so that I only have to make one database query, and the two values (CountOne, and CountTwo) will get returned to me

Any help\pointers greatly appreciated,

Noel Received on Thu Jul 07 2005 - 06:55:42 CDT