So I have this table below
Id, SiteID, Name, ParentOrgId, Supervisor, SupvAlt1, SupvAlt2
44 33 x 5 bob lisa tammy
47 36 b 44 Jim tammy dave
55 36 ba 47 Dan amy george
56 36 baa 55 bert erney mike
I need do a select that will grab a record from an ID and also the parentOrgId before it untill it is a different SiteID
So if I passed it 56, it would get 55, then47, then 44