Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. USE [ITLKEUANGANDEV]
  2. GO
  3.  
  4. /****** Object: StoredProcedure [dbo].[SPSyncJurnal] Script Date: 20/02/2019 09.27.59 ******/
  5. SET ANSI_NULLS ON
  6. GO
  7.  
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10.  
  11. ALTER procedure [dbo].[SPSyncJurnal] @startdate datetime, @enddate datetime
  12. as
  13. delete from [dbo].[DokumenKeuJurnalPendapatan] where VCRDATE >= @startdate and VCRDATE <= @enddate
  14. GO
  15. insert into [dbo].[DokumenKeuJurnalPendapatan]([VCRNO],[VCRDATE],[REM],[AMOUNT],[NIM],[THNAKD],[SEMAKD],[ACC],[REMARK],[DBAMOUNT],[CRAMOUNT],[id])
  16. select [VCRID],[VCRNO],[CHECKNO],[VCRDATE],[REMARK],[ACC],[ACCNAME],[DBAMOUNT],[CRAMOUNT],newid() from [dbo].[ViewJurnalPengeluaranHarry] where [VCRDATE] >= @startdate and [VCRDATE] <= @enddate
  17. go
  18. delete from [dbo].[DokumenKeuJurnalPengerluaran] where VCRDATE >= @startdate and VCRDATE <= @enddate
  19. go
  20. insert into [dbo].[DokumenKeuJurnalPengerluaran] where VCRDATE >= @startdate and VCRDATE <= @enddate
  21. select [VCRID],[VCRNO],[CHECKNO],[VCRDATE],[REMARK],[ACC],[ACCNAME],[DBAMOUNT],[CRAMOUNT],newid() from [dbo].[ViewJurnalPengeluaranHarry] where [VCRDATE] >= @startdate and [VCRDATE] <= @enddate
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement