DefconDotNet

Untitled

Apr 19th, 2013
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. SELECT * FROM (
  2.     SELECT
  3.          MIN(MutDatum) AS MutDatum,
  4.      MIN(MutBetalingskenmerk) AS MutBetalingskenmerk,
  5.          MutFactuur,
  6.      Mut_Rel_ID,
  7.          SUM(CASE WHEN MutPartNr=1 AND mutsoort = 2 THEN (mutbedragex+mutbtw) ELSE NULL END) AS topay,
  8.      SUM(CASE WHEN MutPartNr=3 AND mutsoort IN (7, 3) THEN mutrekenbedrag ELSE 0 END) AS paid
  9.     FROM tblBH_Mutaties
  10.     WHERE Mut_Ab_ID = 71
  11.     GROUP BY MutFactuur,Mut_Rel_ID
  12.     ) AS m
  13. WHERE m.paid <> m.topay
  14. ORDER BY MutFactuur
Advertisement
Add Comment
Please, Sign In to add comment