daily pastebin goal
3%
SHARE
TWEET

Untitled

a guest Feb 19th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top