DefconDotNet

Untitled

Apr 19th, 2013
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.78 KB | None | 0 0
  1.  
  2. SELECT * FROM
  3. (SELECT
  4.     x.MutDatum,
  5.     x.MutFactuur,
  6.     x.MutBetalingskenmerk,
  7.     x.Mut_Rel_ID,
  8.     x.sBedrag,
  9.     (CASE WHEN x.sBetaald IS NULL THEN 0 ELSE x.sBetaald END) AS sBetaald2
  10. FROM
  11. (SELECT
  12.     MutDatum,MutFactuur,MutBetalingskenmerk,Mut_Rel_ID,SUM(MutBedragEX+MutBTW) AS sBedrag,
  13.     (SELECT TOP 1 RelCode FROM tblBH_Relaties WHERE Rel_ID=Mut_Rel_ID) AS RelCode,
  14.     (SELECT SUM(b.MutRekenBedrag)
  15.      FROM tblBH_Mutaties b
  16.      WHERE b.Mut_Ab_ID=71 AND b.MutPartNr=3 AND (b.MutSoort=7 OR b.MutSoort=3)
  17.       AND b.MutFactuur=tblBH_Mutaties.MutFactuur AND b.Mut_Rel_ID=tblBH_Mutaties.Mut_Rel_ID) AS sBetaald
  18.  
  19.  FROM tblBH_Mutaties
  20.  WHERE Mut_Ab_ID=71 AND MutPartNr=1 AND MutSoort=2
  21.  GROUP BY MutDatum,MutFactuur,MutBetalingskenmerk,Mut_Rel_ID) AS X) AS Z  WHERE z.sBetaald2<>z.sBedrag
Advertisement
Add Comment
Please, Sign In to add comment