SELECT DISTINCT
  CZ.ClientID,
  TRIM(CZ.GroupNameExt) AS GroupName
FROM
  taClientSummary AS CZ
WHERE
  (TRIM(CZ.GroupNameExt) <> '')
  @pBranchID
  @pProductID
  @pBranchRegion
  @pProductCategory
  @pClientStatus
  @pBranchStatus
  @pStatus
ORDER BY
  CZ.GroupNameExt