id | claimantID | agentID | claimantContactIndex | agentContactIndex | claimantContactID | agentContactID
    --------------------------------
    1 | 1001 | 2001 | 2 | 0 | 0 | 0
    2 | 1002 | NULL | 0 | NULL | 0 | 0

id | name | address | phone | email
    --------------------------------
    1001 | Widgets Inc. | 123 W. Main | 5550000 | widgets@here.com
    1002 | Thingies LLC. | 456 W. Main | 5551111 | thingies@here.com

id | name | address | phone | email
    --------------------------------
    2001 | Simon Bros. | 789 W. Main | 5552222 | simon@here.com

id | claimantID | agentID | fn | ln | phone | email
    --------------------------------
    3001 | 1001 | NULL | John | Doe | 5553333 | john@here.com
    3002 | 1001 | NULL | Fred | Flynn | 5554444 | fred@here.com
    3003 | 1001 | NULL | Mike | Brown | 55555555 | mike@here.com
    3004 | 1001 | NULL | Susan | Pierce | 5556666 | susan@here.com
    3005 | NULL | 2001 | Jeff | Bridges | 5557777 | jeff@here.com
    3006 | NULL | 2001 | Karry | Sinclair | 5558888 | Karry@here.com
    3007 | NULL | 2001 | Steve | Green | 5559999 | steve@here.com
    3008 | NULL | 2001 | Peter | White | 5550001 | peter@here.com

SELECT
    ROW_NUMBER() OVER (Order by Id) AS RowNumber,
    claimantID, agentID, (etc...)
FROM
    tblContacts