dbo.QBM_FGIDateTimeSpanOverlap

SQL_SCALAR_FUNCTION

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

Open formatted source/search result

Parameters

Name	Type	Output
	bit	yes
`@From1`	datetime	no
`@To1`	datetime	no
`@From2`	datetime	no
`@To2`	datetime	no
`@ToDatewWithAutoEvening`	bit	no

Referenced objects

Schema	Object	Column/minor	Class
No SQL expression dependencies in snapshot.

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_FGIDateTimeSpanOverlap(@From1 datetime , @To1 datetime , @From2 datetime , @To2 datetime , @ToDatewWithAutoEvening
2 bit ) returns bit with SCHEMABINDING as begin  declare @Erg bit = 0 declare @From1_I datetime = isnull(@From1, '1899-12-30') declare @From2_I datetime
3 = isnull(@From2, '1899-12-30') declare @To1_I datetime declare @To2_I datetime if @ToDatewWithAutoEvening = 0 begin select @To1_I = isnull(@To1, '2200-01-01'
4) select @To2_I = isnull(@To2, '2200-01-01') end else begin  select @To1_I = @To1 select @To2_I = @To2 if convert(datetime, CONVERT(date, @To1_I)) = @To1_I
5 begin select @To1_I = DATEADD(SS, 86399, @To1_I)  end if convert(datetime, CONVERT(date, @To2_I)) = @To2_I begin select @To2_I = DATEADD(SS, 86399, @To2_I
6)  end select @To1_I = isnull(@To1_I, '2200-01-01') select @To2_I = isnull(@To2_I, '2200-01-01') end     if @From1_I >= @From2_I begin  if @To1_I <= @To2_I
7 begin select @Erg = 1  return(@erg)  end  if @To2_I between @From1_I and @To1_I begin select @Erg = 1  return(@erg)  end end else  begin  if @To2_I <=
8 @To1_I begin select @Erg = 1  return(@erg)  end  if @To1_I between @From2_I and @To2_I begin select @Erg = 1  return(@erg)  end end endLabel: return(@erg
9) 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:14:10.560

None extracted.

Summary: No calls/DML/dependency patterns extracted by the current parser.

Declared parameters

Parameter	Type	Direction
	`bit`	OUTPUT
`@From1`	`datetime`	input
`@To1`	`datetime`	input
`@From2`	`datetime`	input
`@To2`	`datetime`	input
`@ToDatewWithAutoEvening`	`bit`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

None extracted.

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @From1 @To1 @From2 @To2 @ToDatewWithAutoEvening @Erg @From1_I @From2_I @To1_I @To2_I @erg

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_FTDateTimeGaps	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FGIPwoValidDateRangeAssign	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FGIPwoValidDateRangesExist	SQL expression dependency	dbo · OBJECT_OR_COLUMN