dbo.QBM_ZGroupPattern
SQL_STORED_PROCEDURE
Created 2025-06-27T17:58:58.467 · modified 2026-04-14T23:20:29.123 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@Slotnumber | int | no |
@uid_dialogGroup | varchar | no |
@dummy2 | varchar | no |
@GenProcID | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| DialogGroup | OBJECT_OR_COLUMN | ||
| QBM_PSessionContextSet | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| dbo | QBM_FCVBinarySetBit | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionContext | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create procedure QBM_ZGroupPattern ( @Slotnumber int ,@uid_dialogGroup varchar(38) , @dummy2 varchar(38) , @GenProcID varchar(38) ) as begin 2 declare @Groupnumber int declare @neu int declare @GroupBitPattern varbinary(200) declare @VectorLen int declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext 3('') BEGIN TRY if not exists (select top 1 1 from DialogGroup where uid_dialogGroup = @uid_dialogGroup ) begin goto ende end select @VectorLen = (isnull 4(max(GroupNumber), 0) / 8)+ 1 from dialogGroup if isnull(@VectorLen, 0) < 32 begin select @VectorLen = 32 end select top 1 @Groupnumber = Groupnumber from 5 dialogGroup where uid_dialogGroup = @uid_dialogGroup select @GroupBitPattern = convert(varbinary(200), replicate(0x00, @VectorLen)) select @GroupBitPattern 6 = dbo.QBM_FCVBinarySetBit (@GroupBitPattern, @Groupnumber) exec QBM_PSessionContextSet 'GenProcID', @GenProcID update dialogGroup set GroupBitPattern 7= @GroupBitPattern, xdateupdated = GetUTCDate(), Xuserupdated = 'DBScheduler' where uid_dialogGroup = @uid_dialogGroup and isnull(GroupBitPattern, 0x00 8) <> @GroupBitPattern END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: exec QBM_PSessionContextSet 9 'GenProcID', @GenProcID_R return end 10
Module relation graph
Loading module relation graph…
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:29.123
uses session context values has TRY/CATCH error handling
Summary: calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE dialogGroup; reads/joins DialogGroup, dialogGroup; uses session context GenProcID
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@Slotnumber | int | input |
@uid_dialogGroup | varchar(38) | input |
@dummy2 | varchar(38) | input |
@GenProcID | varchar(38) | input |
DML targets
UPDATE dialogGroupCalled routines
Read/join references
SQL dependency metadata
Config/session
Config: None extracted.
Session: GenProcID
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @Slotnumber @uid_dialogGroup @dummy2 @GenProcID @Groupnumber @neu @GroupBitPattern @VectorLen @GenProcID_R
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
No reverse dependencies extracted.