dbo.QBM_PTDialogScheduleReferences

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:28.717 · modified 2026-04-14T23:20:24.653 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@UID_DialogSchedule`	varchar	no

Referenced objects

Schema	Object	Class
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_VQBMRelation	OBJECT_OR_COLUMN
dbo	QBM_FGISessionErrorRethrow	OBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1    create   procedure QBM_PTDialogScheduleReferences (@UID_DialogSchedule varchar(38) ) as begin declare @Cmd nvarchar(max) = '' declare @DebugSwitch
2 int = 0 SET XACT_ABORT OFF BEGIN TRY select @cmd = string_agg(convert(nvarchar(max), case r.IsMNRelation when 0 then N'select ''' + r.ChildTable + ''' as ReferencedTable, '''
3 + r.ChildColumn + ''' as ReferencedColumn 
4				, x.XObjectKey as ReferencedElement
5				from ' + r.ChildTable + '  x
6				where ' + r.ChildColumn + ' = '''
7 + @UID_DialogSchedule + '''
8			' else N'select ''' + r.ChildTable + ''' as ReferencedTable, ''' + r.ChildColumn + ''' as ReferencedColumn 
9				, y.XObjectKey as ReferencedElement
10				from '
11 + r.childtable + ' x join ' + mn.Parenttable + ' y on x.' + mn.childcolumn + '  = y.' + mn.parentcolumn + '
12				where ' + r.ChildColumn + ' = ''' + @UID_DialogSchedule
13 + '''
14			' end )  , concat(N'			union all ', nchar(13), nchar(10)) )  from QBM_VQBMRelation r left outer join QBM_VQBMRelation mn on r.UID_QBMRelationMN
15 = mn.UID_QBMRelation where r.ParentTable = 'DialogSchedule' if @DebugSwitch > 0 begin print @cmd end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default
16 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: exec sp_executesql @cmd 
17end 
18

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:24.653

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; reads/joins QBM_VQBMRelation

Declared parameters

Parameter	Type	Direction
`@UID_DialogSchedule`	`varchar(38)`	input

DML targets

None extracted.

Called routines

QBM_PSessionErrorAdd

Read/join references

QBM_VQBMRelation

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_DialogSchedule @Cmd @DebugSwitch @cmd @Rethrow

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.