SQL query to retrieve base members of a hierarchy

Hi, All Just wanted to share a SQL query I wrote to retrieve base members and parent of a given hierarchy from within a dashboard grid.  (Note that the parameter supplies the member ID of the top m...