Truncate table if tailor made switch is off
--Function Code : PRSFRT/SQPRSFR
--PRMRTHT MaterialReservationTransferDetailTempEntity
--PRMRTD MaterialReservationTransferDetailEntity
--PRMRTH MaterialReservationTransferEntity
Declare @DB_DATABASE Nvarchar(128)
Declare @Sql Nvarchar(400)
DECLARE @TAILOR_HEILEI BIT
SELECT @TAILOR_HEILEI=TAILOR_HEILEI FROM dbo.ADPARM
IF @TAILOR_HEILEI=0
BEGIN
Declare Cur Cursor For Select DB_DATABASE From dbo.ADCOMP WHERE SUSPENDED='N'
Open Cur
Fetch next From Cur Into @DB_DATABASE
While @@fetch_status=0
BEGIN
SELECT @Sql=''
SELECT @Sql='DELETE '+@DB_DATABASE +'.dbo.PRMRTD'
EXECUTE (@Sql)
SELECT @Sql=''
SELECT @Sql='DELETE '+@DB_DATABASE +'.dbo.PRMRTH'
EXECUTE (@Sql)
SELECT @Sql=''
SELECT @Sql='DELETE '+@DB_DATABASE+'.dbo.PRMRTHT'
EXECUTE (@Sql)
Fetch next From Cur Into @DB_DATABASE
End
Close Cur
Deallocate Cur
END