SQL for Pledge payment writeoff

Alex Wong

SELECT

  g.id AS 'Gift System ID',CAST(g.dte AS DATE) AS 'Pledge Date',g.amount AS 'Pledge Amount',

  paywo.pay AS 'Total Payment',paywo.wo AS 'Total Write Off'

FROM gift AS g

LEFT JOIN (

  SELECT

    pp.pledgeid,

    SUM(CASE WHEN g.type<>21 THEN pp.amount ELSE 0.00 END) AS pay,

    SUM(CASE WHEN g.type=21 THEN pp.amount ELSE 0.00 END) AS wo

  FROM pledgepayments AS pp

  LEFT JOIN gift AS g ON g.id=pp.paymentid

  GROUP BY pp.pledgeid

) AS paywo ON paywo.pledgeid=g.id

WHERE g.type=8 AND g.amount>0

Alex Wong

1. test ordered list
   1. sub list
   2. asdf
2. test ordered list

• test unordered
• unordered

Alex Wong

All-Star Testing for New Platform.xlsx

Alex Wong

https://blackbaud.vanillacommunities.com/discussion/81655/sql-for-pledge-payment-writeoff