Dave:

You should have scrolled right on the sample, there was a second column. How about:

Code:
SELECT company_parent_id,
       ROW_NUMBER() OVER (PARTITION BY company_parent_id
                          ORDER BY company_parent_id) gen
FROM company
John