CREATE TABLE TESTA
(ID INT
, PID INT
, MONEY INT)

INSERT INTO TESTA
SELECT ID = 1 , PID = 0 , MONEY = 0 UNION ALL
  SELECT 2,  1 , 3000 UNION ALL
  SELECT 3, 1, 0 UNION ALL
  SELECT 4 , 3, 3000 UNION ALL
  SELECT 5, 3, 5000

SELECT
 A.ID
 , A.PID
 , A.MONEY
 , B.SUM_CNT
 , SS = CASE WHEN A.PID = 0 THEN B.SUM_CNT
    ELSE
     CASE WHEN EXISTS (SELECT 1 FROM TESTA WHERE PID = A.PID  AND ID > A.ID) THEN B.SUM_CNT
       ELSE 0
     END
   END
 
FROM
 TESTA A
LEFT OUTER JOIN
 (
  SELECT
   PID = ISNULL(PID, 0)
   , SUM_CNT = SUM(MONEY)
  FROM
   TESTA
  GROUP BY
   PID
   WITH ROLLUP
   HAVING SUM(MONEY) > 0
 ) B
ON A.PID = B.PID

답변 감사드립니다..커서를 이용안하고도 가능하군요..-ㅅ-;;

왜 저런생각은 못했는지 원...ㅠ,ㅜ;