Advertisement
Guest User

Untitled

a guest
Jan 24th, 2020
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. select
  2. SONmbr data_transaksi_id
  3. ,'P.2.0008720.05.003' nopd
  4. ,SUM(SONetto) nilai_transaksi
  5. ,SUM(SOPPN) pajak_transaksi
  6. ,MIN(Upddate) waktu_transaksi
  7. ,SONmbr private_key
  8. ,'1' AS '@version'
  9. ,MIN(Upddate) '@timestamp'
  10. ,'KUNCI '+ CAST(SONmbr AS CHAR)
  11. + CHAR(10)+ 'nilai_transaksi '+ CAST(SUM(SONetto) AS CHAR)
  12. + CHAR(10)+ 'pajak_transaksi '+ CAST(SUM(SOPPN) AS CHAR)
  13. + CHAR(10)+ 'SONmbr '+ CAST(SONmbr AS CHAR)
  14. keterangan
  15. FROM dbo.V_SLJINSODt
  16. WHERE Upddate >= DATEADD(DAY,-60,GETDATE())
  17. GROUP BY SONmbr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement