Jejes.. I can see your plurk. And I reply it..

i also can see it.. ah pahuri somse

hehehehe......dasar, kata pahuri, sok ga penting gt...

ih ada sonson

SELECT LAPBUL_JENIS, CASE WHEN LEFT(GSL, 1) = '1' THEN SUM(ENDING_BAL_LCY * - 1) ELSE SUM(ENDING_BAL_LCY) END AS AKUMULASI_PENYUSUTAN

FROM dbo.GSL_OTHERS WHERE (BI_LINE = '021501' OR BI_LINE = '021502') AND (LAPBUL_FORM_ID = 'LB15')

GROUP BY LAPBUL_JENIS, BI_LINE, LEFT(GSL,1)

jejes........................

gilingan....plurk lo isinya query smua