Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- SONmbr data_transaksi_id
- ,'P.2.0008720.05.003' nopd
- ,SUM(SONetto) nilai_transaksi
- ,SUM(SOPPN) pajak_transaksi
- ,MIN(Upddate) waktu_transaksi
- ,SONmbr private_key
- ,'1' AS '@version'
- ,MIN(Upddate) '@timestamp'
- ,'KUNCI '+ CAST(SONmbr AS CHAR)
- + CHAR(10)+ 'nilai_transaksi '+ CAST(SUM(SONetto) AS CHAR)
- + CHAR(10)+ 'pajak_transaksi '+ CAST(SUM(SOPPN) AS CHAR)
- + CHAR(10)+ 'SONmbr '+ CAST(SONmbr AS CHAR)
- keterangan
- FROM dbo.V_SLJINSODt
- WHERE Upddate >= DATEADD(DAY,-60,GETDATE())
- GROUP BY SONmbr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement