DECLARE @FindParentsForMember INT;
SET @FindParentsForMember = 757;
WITH Hierarchy(MemId,ParentId)
AS(
SELECT DISTINCT parent.MemId,parent.ParentId
FROM Members parent
WHERE parent.MemId = @FindParentsForMember
UNION ALL
SELECT child.MemId,child.ParentId
FROM Members child
INNER JOIN Hierarchy parent ON parent.ParentId = child.MemId
)
SELECT DISTINCT ParentId
FROM Hierarchy