dbo.TSB_ZUNSAccountBHasUNSItemB

1       create   procedure TSB_ZUNSAccountBHasUNSItemB (@SlotNumber int) AS begin declare @Sourcedata QBM_YDataForDelta , @CountDeltaQantity int 
2, @CountDeltaOrigin int declare @GenProcID varchar(38) declare @DBQueueCurrent QBM_YDBQueueCurrent declare @QBM_BitPatternXOrigin_Inherit int = dbo.QBM_FGIBitPatternXOrigin
3('|Inherit|', 0) declare @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|', 1)  BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue
4, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast
5) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  insert into @SourceData( IsUpcommingContent, XOriginAfter , Element, AssignedElement
6, XOriginBefore , XIsInEffectBefore, XIsInEffectAfter ) select 0, 0 , aig.UID_UNSAccountB, aig.UID_UNSItemB, aig.XOrigin , aig.XIsInEffect, 0 from UNSAccountBHasUNSItemB
7 aig join @DBQueueCurrent x on UID_UNSAccountB = x.UID_parameter insert into @SourceData( IsUpcommingContent, XOriginBefore, XOriginAfter , Element, AssignedElement
8 , XIsInEffectBefore, XIsInEffectAfter ) select 1, 0, aig.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv , aig.UID_UNSAccountB, aig.UID_UNSItemB , aig.XIsInEffect
9, case when n.UID_UNSRootB = g.UID_UNSRootB then 1  when ns.IsExtendedInheritance = 0 then 0 when ns.IsExtendedInheritance = 1 and ns.UID_DPRNameSpace 
10= rg.UID_DPRNameSpace then 1 else 0 end from UNSAccountBHasUNSItemB aig join @DBQueueCurrent x on aig.UID_UNSAccountB = x.UID_parameter  join UNSAccountB
11 n on aig.UID_UNSAccountB = n.UID_UNSAccountB join UNSItemB g on aig.UID_UNSItemB = g.UID_UNSItemB   join UNSRootB rn on n.UID_UNSRootB = rn.UID_UNSRootB
12 join DPRNameSpace ns on rn.UID_DPRNameSpace = ns.UID_DPRNameSpace join UNSRootB rg on g.UID_UNSRootB = rg.UID_UNSRootB insert into @SourceData( IsUpcommingContent
13, XOriginBefore , Element, AssignedElement, XOriginAfter , XIsInEffectBefore, XIsInEffectAfter ) select 1, 0 , va.UID_UNSAccountB, t.uid_UnsItemB, @QBM_BitPatternXOrigin_Inherit
14 , 0, 1 from (  select uig.UID_UNSGroupB, uig.UID_UNSAccountB from UNSAccountBInUNSGroupB uig join @DBQueueCurrent x on uig.UID_UNSAccountB = x.UID_parameter
15 and uig.XOrigin > 0 and uig.XIsInEffect = 1 union select uig.UID_UNSGroupB, uig.UID_UNSAccountB from UNSAccountBHasUNSGroupB uig join @DBQueueCurrent 
16x on uig.UID_UNSAccountB = x.UID_parameter and uig.XOrigin > 0 and uig.XIsInEffect = 1 ) as va join UNSGroupBHasUNSItemB t on t.uid_UNSGroupB = va.UID_UNSGroupB
17 and t.XIsInEffect = 1 and t.XOrigin > 0 and t.XIsInEffect = 1  join UNSAccountB n on va.UID_UNSAccountB = n.UID_UNSAccountB join UNSItemB g on t.UID_UNSItemB
18 = g.UID_UNSItemB  join UNSRootB rn on n.UID_UNSRootB = rn.UID_UNSRootB join DPRNameSpace ns on rn.UID_DPRNameSpace = ns.UID_DPRNameSpace join UNSRootB
19 rg on g.UID_UNSRootB = rg.UID_UNSRootB where 1 = case when n.UID_UNSRootB = g.UID_UNSRootB then 1  when ns.IsExtendedInheritance = 0 then 0 when ns.IsExtendedInheritance
20 = 1 and ns.UID_DPRNameSpace = rg.UID_DPRNameSpace then 1 else 0 end   exec QBM_PDBQueueCalculateDelta @SourceData, @DeltaQuantity = 0, @DeltaDelete = 
210, @DeltaInsert = 1, @DeltaOrigin = 1, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin output , @UseIsInEffect =
22 1 , @SlotNumber = @SlotNumber , @DBQueueCurrentExtern = @DBQueueCurrent if @CountDeltaOrigin > 0 begin exec QBM_PMNTableOriginUpdate 'UNSAccountBHasUNSItemB'
23, 'UID_UNSAccountB', 'UID_UNSItemB' end if @CountDeltaQantity > 0 begin exec QBM_PMNTableInsert 'UNSAccountBHasUNSItemB', 'UID_UNSAccountB', 'UID_UNSItemB'
24, @TargetIsView = 0 , @FKTableNameElement = 'UNSAccountB' , @FKColumnNameElement = 'UID_UNSAccountB' end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd 
25default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 
26