Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [ITLKEUANGANDEV]
- GO
- /****** Object: StoredProcedure [dbo].[SPSyncJurnal] Script Date: 20/02/2019 09.27.59 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER procedure [dbo].[SPSyncJurnal] @startdate datetime, @enddate datetime
- as
- delete from [dbo].[DokumenKeuJurnalPendapatan] where VCRDATE >= @startdate and VCRDATE <= @enddate
- GO
- insert into [dbo].[DokumenKeuJurnalPendapatan]([VCRNO],[VCRDATE],[REM],[AMOUNT],[NIM],[THNAKD],[SEMAKD],[ACC],[REMARK],[DBAMOUNT],[CRAMOUNT],[id])
- select [VCRID],[VCRNO],[CHECKNO],[VCRDATE],[REMARK],[ACC],[ACCNAME],[DBAMOUNT],[CRAMOUNT],newid() from [dbo].[ViewJurnalPengeluaranHarry] where [VCRDATE] >= @startdate and [VCRDATE] <= @enddate
- go
- delete from [dbo].[DokumenKeuJurnalPengerluaran] where VCRDATE >= @startdate and VCRDATE <= @enddate
- go
- insert into [dbo].[DokumenKeuJurnalPengerluaran] where VCRDATE >= @startdate and VCRDATE <= @enddate
- 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