Facebook
From Mungo Cockroach, 1 Year ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 83
  1. SELECT
  2.     ROW_NUMBER() OVER(ORDER BY CAB.NUNOTA,ITE.AD_NUEQP) AS SEQ,
  3.     ITE.AD_NUEQP,
  4.     CAB.NUNOTA,
  5.     CAB.CODPARC,
  6.     CAB.DTNEG,
  7.     ITE.AD_DTPREVDEV,
  8.     ITE.AD_DTDEVREAL,
  9.     ITE.AD_DTDEVREAL - ITE.AD_DTPREVDEV AS QTDDIASVENC,
  10.     ITE.VLRTOT,
  11.     ((ITE.AD_DTDEVREAL - ITE.AD_DTPREVDEV) * ITE.VLRUNIT) AS MULTA,
  12.     ((ITE.AD_DTDEVREAL - ITE.AD_DTPREVDEV) * ITE.VLRUNIT) + ITE.VLRTOT AS TOTAL_MULTA
  13. FROM
  14.     TGFCAB CAB
  15.     INNER JOIN TGFITE ITE ON CAB.NUNOTA = ITE.NUNOTA
  16. WHERE
  17.     CAB.CODTIPOPER = 604
  18.     AND ITE.AD_NUEQP = 2
  19.