ALTER PROCEDURE [dbo].[aspx_Products_GetRecordCountByCategoryID]

(

   @categoryID int

)

AS

BEGIN

  SET NOCOUNT ON;

  SELECT COUNT(*) AS RecordCount FROM [dbo].[Products]

  WHERE [CategoryID] = @categoryID

END