Back to OIM Explorer

dbo.QBM_FGICutOffTaskExists

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 2.199 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL89 lines
1CREATE FUNCTION dbo.QBM_FGICutOffTaskExists(2  @UID_Task varchar(38)3) RETURNS int4AS5BEGIN6  DECLARE @erg int = 07  DECLARE @CutOffTaskLevel int = 08  DECLARE @InitialPathlength int = 10009  IF NOT EXISTS(10    SELECT TOP 1 111    FROM DialogDatabase d12    WITH(readpast)13  WHERE14    d.UID_CutOffTask = @UID_Task AND d.IsMainDatabase = 1)15  BEGIN16    GOTO EndLabel17  END18  SELECT @erg = -119  SELECT TOP 1 @CutOffTaskLevel = m.PathLength - 120  FROM QBMDBQueueTaskMetric m21    WITH(readpast)22  WHERE23    m.UID_Task = @UID_Task24  IF EXISTS(25    SELECT TOP 1 126    FROM DialogDBQueue q27    WITH(nolock)28  WHERE29    (q.PathLength BETWEEN @InitialPathlength AND @CutOffTaskLevel OR(@UID_Task = 'QBM-K-BaseMigrationReady' AND q.UID_Task IN('QBM-K-FillModelStart'30  , 'QBM-K-BufferTProcessModule', 'QBM-K-BufferTProcessModulePU', 'QBM-K-BufferTProcessTable', 'QBM-K-BufferTProcessTablePU',31  'QBM-K-BufferTProcessDelete', 'QBM-K-FillModelFinished'))) AND q.Generation >= 0)32  BEGIN33    GOTO EndLabel34  END35  IF EXISTS(36    SELECT TOP 1 137    FROM QBMDBQueueCurrent cu38    WITH(nolock)39  WHERE40    cu.SlotNumber > 0)41  BEGIN42    IF EXISTS(43      SELECT TOP 1 144      FROM QBMDBQueueCurrent cu45      WITH(nolock)46    LEFT47    OUTER48    JOIN QBMDBQueueTaskMetric m49      WITH(nolock)50      ON cu.UID_Task = m.UID_Task51    WHERE52      cu.SlotNumber > 0 AND ISNULL(m.PathLength, 0) BETWEEN @InitialPathlength AND @CutOffTaskLevel)53    BEGIN54      GOTO EndLabel55    END56  END57  IF EXISTS(58    SELECT TOP 1 159    FROM DialogDBQueue q60    WHERE61      (q.PathLength BETWEEN @InitialPathlength AND @CutOffTaskLevel OR(@UID_Task = 'QBM-K-BaseMigrationReady' AND q.UID_Task IN('QBM-K-FillModelStart'62  , 'QBM-K-BufferTProcessModule', 'QBM-K-BufferTProcessModulePU', 'QBM-K-BufferTProcessTable', 'QBM-K-BufferTProcessTablePU',63  'QBM-K-BufferTProcessDelete', 'QBM-K-FillModelFinished'))) AND q.Generation >= 0)64  BEGIN65    GOTO endLabel66  END67  IF EXISTS(68    SELECT TOP 1 169    FROM QBMDBQueueCurrent cu70    WHERE71      cu.SlotNumber <> 0)72  BEGIN73    IF EXISTS(74      SELECT TOP 1 175      FROM QBMDBQueueCurrent cu76    LEFT77    OUTER78      JOIN QBMDBQueueTaskMetric m79      WITH(readpast)80      ON cu.UID_Task = m.UID_Task81    WHERE82      cu.SlotNumber <> 0 AND ISNULL(m.PathLength, 0) BETWEEN @InitialPathlength AND @CutOffTaskLevel)83    BEGIN84      GOTO EndLabel85    END86  END87  SELECT @erg = 1 EndLabel:88  RETURN(@erg)89END
Open raw exported source
SQL ยท Raw15 lines
1 create   function dbo.QBM_FGICutOffTaskExists (@UID_Task varchar(38)  ) returns int  as begin declare @erg int = 0 declare @CutOffTaskLevel int2 = 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.IsMainDatabase3 = 1 ) begin goto EndLabel end select @erg = -1 select top 1 @CutOffTaskLevel = m.PathLength - 1 from QBMDBQueueTaskMetric m with (readpast) where m.UID_Task4 = @UID_Task if exists (select top 1 1 from DialogDBQueue q with (nolock) where (q.PathLength between @InitialPathlength and @CutOffTaskLevel or (@UID_Task5 = '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 end7 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 between10 @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 exists13 (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