Stored Procedures [dbo].[XLedgerDeleteUnencounteredSubledgerHiddenIndicators]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@xLedgerSyncHistoryIdint4
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
CREATE PROCEDURE [dbo].[XLedgerDeleteUnencounteredSubledgerHiddenIndicators]
    @xLedgerSyncHistoryId int
AS
begin
set nocount on

    declare @items PriKeyToIntMap

    insert into @items(Id,Value)
        select XLedgerHiddenSubledger.XLedgerDbId, null
    from XLedgerHiddenSubledger
    where XLedgerSyncHistoryFid is null or XLedgerSyncHistoryFid <> @xLedgerSyncHistoryId

    exec XLedgerImportSubledgerHiddenIndicators
        @items = @items,
        @xLedgerSyncHistoryId = @xLedgerSyncHistoryId
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerDeleteUnencounteredSubledgerHiddenIndicators] TO [MssExec]
GO
Uses