DefconDotNet

Untitled

Apr 19th, 2013
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. SELECT DISTINCT m.MutFactuur, m1.topay, m2.paid
  2. FROM tblBH_Mutaties m
  3.  CROSS apply (SELECT SUM(MutBedragEX+MutBTW) AS topay FROM tblBH_Mutaties WHERE 71 = Mut_Ab_ID AND MutFactuur=m.MutFactuur AND MutPartNr=1 AND mutsoort = 2) m1
  4.  CROSS apply (SELECT SUM(MutRekenBedrag)     AS paid  FROM tblBH_Mutaties WHERE 71 = Mut_Ab_ID AND MutFactuur=m.MutFactuur AND MutPartNr=1 AND (mutsoort = 7 OR mutsoort = 3)) m2
  5. WHERE m1.topay <> m2.paid
  6.   AND Mut_Ab_ID = 71
  7. ORDER BY mutfactuur
Advertisement
Add Comment
Please, Sign In to add comment