dbo.QBM_FGICutOffTaskExists

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:57:37.333 · modified 2026-04-14T23:16:09.040 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	int	yes
`@UID_Task`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
	DialogDatabase		OBJECT_OR_COLUMN
	DialogDBQueue		OBJECT_OR_COLUMN
	QBMDBQueueCurrent		OBJECT_OR_COLUMN
	QBMDBQueueTaskMetric		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   function dbo.QBM_FGICutOffTaskExists (@UID_Task varchar(38)  ) returns int  as begin declare @erg int = 0 declare @CutOffTaskLevel int
2 = 0 declare @InitialPathlength int = 1000 if not exists (select top 1 1 from DialogDatabase d with (readpast) where d.UID_CutOffTask = @UID_Task and d.IsMainDatabase
3 = 1 ) begin goto EndLabel end select @erg = -1 select top 1 @CutOffTaskLevel = m.PathLength - 1 from QBMDBQueueTaskMetric m with (readpast) where m.UID_Task
4 = @UID_Task if exists (select top 1 1 from DialogDBQueue q with (nolock) where (q.PathLength between @InitialPathlength and @CutOffTaskLevel or (@UID_Task
5 = 'QBM-K-BaseMigrationReady' and q.UID_Task in ( 'QBM-K-FillModelStart' ,'QBM-K-BufferTProcessModule'  , 'QBM-K-BufferTProcessModulePU'  , 'QBM-K-BufferTProcessTable'
6  , 'QBM-K-BufferTProcessTablePU'  , 'QBM-K-BufferTProcessDelete'  , 'QBM-K-FillModelFinished'  ) )  )  and q.Generation >= 0   ) begin goto EndLabel end
7 if exists (select top 1 1 from QBMDBQueueCurrent cu with (nolock) where cu.SlotNumber > 0  ) begin   if exists (select top 1 1 from QBMDBQueueCurrent 
8cu with (nolock) left outer join QBMDBQueueTaskMetric m with (nolock) on cu.UID_Task = m.UID_Task where cu.SlotNumber > 0  and ISNULL(m.PathLength, 0) 
9between @InitialPathlength and @CutOffTaskLevel ) begin goto EndLabel end end   if exists (select top 1 1 from DialogDBQueue q  where (q.PathLength between
10 @InitialPathlength and @CutOffTaskLevel or (@UID_Task = 'QBM-K-BaseMigrationReady' and q.UID_Task in ( 'QBM-K-FillModelStart' ,'QBM-K-BufferTProcessModule'
11  , 'QBM-K-BufferTProcessModulePU'  , 'QBM-K-BufferTProcessTable'  , 'QBM-K-BufferTProcessTablePU'  , 'QBM-K-BufferTProcessDelete'  , 'QBM-K-FillModelFinished'
12  ) )  )  and q.Generation >= 0   ) begin goto endLabel end if exists (select top 1 1 from QBMDBQueueCurrent cu  where cu.SlotNumber <> 0 ) begin  if exists
13 (select top 1 1 from QBMDBQueueCurrent cu left outer join QBMDBQueueTaskMetric m with (readpast) on cu.UID_Task = m.UID_Task where cu.SlotNumber <> 0 
14 and ISNULL(m.PathLength, 0) between @InitialPathlength and @CutOffTaskLevel ) begin goto EndLabel end end select @erg = 1 EndLabel: return(@erg) end 
15

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:16:09.040

None extracted.

Summary: reads/joins DialogDatabase, QBMDBQueueTaskMetric, DialogDBQueue, QBMDBQueueCurrent

Declared parameters

Parameter	Type	Direction
	`int`	OUTPUT
`@UID_Task`	`varchar(38)`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

QBM-K-BaseMigrationReady QBM-K-FillModelStart QBM-K-BufferTProcessModule QBM-K-BufferTProcessModulePU QBM-K-BufferTProcessTable QBM-K-BufferTProcessTablePU QBM-K-BufferTProcessDelete QBM-K-FillModelFinished

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_Task @erg @CutOffTaskLevel @InitialPathlength

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.

Referencing object	Relation	Evidence
dbo.QBM_PMigrationNotReadyForComp	SQL expression dependency	dbo · OBJECT_OR_COLUMN