SELECT
  IF(ProductCategory = @aAdHocProductCategory, 1, 0) AS IsAdHoc,
  ProductCategory,
  TrackingCategory,
  ProductCategoryGroupID AS ProdCatGroupID,
  ProspectChildProducts,
  ProductManagerID,
  BillTravelTime,
  InternalProduct,
  MustHaveParent,
  CoverAllowed,
  @pNavFields
FROM
  taProductCategory
WHERE
  (ProductCategory = @aProductCategory)
