Back to OIM Explorer

dbo.QBM_FTDialogProcessReady

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 3.172 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGIModuleExists source text reference

References

Referenced By

Complete Source

SQL147 lines
1CREATE FUNCTION dbo.QBM_FTDialogProcessReady(2  @ProcessesToCheck dbo.QBM_YSingleGUID READONLY3) RETURNS @erg TABLE(GenProcID varchar(38) collate database_default,4ReadyForDeleteOrExport int DEFAULT 05)6AS7BEGIN8  DECLARE @Worktable dbo.QBM_YSingleGUID9  INSERT INTO @Worktable(UID_SingleGuid,10  IntProperty)11  SELECT12    p.UID_SingleGuid,13    414  FROM @ProcessesToCheck p15  UPDATE @Worktable16  SET IntProperty = 017  FROM @Worktable p18  WHERE19    p.IntProperty = 4 AND EXISTS(20  SELECT TOP 1 121  FROM dbo.DialogDBQueue q22    WITH(nolock)23  WHERE24    q.GenProcID = p.UID_SingleGuid AND q.Generation >= 0)25  UPDATE @Worktable26  SET IntProperty = 027  FROM @Worktable p28  WHERE29    p.IntProperty = 4 AND EXISTS(30  SELECT TOP 1 131  FROM dbo.QBMDBQueueCurrent cu32    WITH(nolock)33  WHERE34    cu.GenProcID = p.UID_SingleGuid)35  UPDATE @Worktable36  SET IntProperty = 037  FROM @Worktable p38  WHERE39    p.IntProperty = 4 AND EXISTS(40  SELECT TOP 1 141  FROM dbo.DialogDeferredOperation de42    WITH(nolock)43  WHERE44    de.GenProcID = p.UID_SingleGuid)45  UPDATE @Worktable46  SET IntProperty = 047  FROM @Worktable p48  WHERE49    p.IntProperty = 4 AND EXISTS(50  SELECT TOP 1 151  FROM dbo.JobQueue q52    WITH(readpast)53  WHERE54    q.GenProcID = p.UID_SingleGuid)55  IF dbo.QBM_FGIModuleExists('QER') = 156  BEGIN57    UPDATE @Worktable58    SET IntProperty = 059    FROM @Worktable p60    WHERE61      p.IntProperty = 4 AND EXISTS(62    SELECT TOP 1 163    FROM dbo.PersonWantsOrg q64      WITH(readpast)65    WHERE66      q.GenProcID = p.UID_SingleGuid)67  END68  UPDATE @Worktable69  SET IntProperty = 070  FROM @Worktable p71  WHERE72    p.IntProperty = 4 AND EXISTS(73  SELECT TOP 1 174  FROM dbo.DialogWatchOperation w75    WITH(nolock)76  WHERE77    w.GenProcID = p.UID_SingleGuid AND w.ReadyForDeleteOrExport IN(0, 1))78  UPDATE @Worktable79  SET IntProperty = 680  FROM @Worktable p81  WHERE82    IntProperty >= 4 AND IntProperty <> 6 AND EXISTS(83  SELECT TOP 1 184  FROM dbo.DialogWatchOperation w85    WITH(nolock)86  WHERE87    w.GenProcID = p.UID_SingleGuid AND w.ReadyForDeleteOrExport = 2)88  UPDATE @Worktable89  SET IntProperty = 090  FROM @Worktable p91  WHERE92    p.IntProperty >= 4 AND EXISTS(93  SELECT TOP 1 194  FROM dbo.DialogProcessChain c95    WITH(nolock)96  WHERE97    c.GenProcID = p.UID_SingleGuid AND c.ReadyForDeleteOrExport IN(0, 1))98  UPDATE @Worktable99  SET IntProperty = 6100  FROM @Worktable p101  WHERE102    p.IntProperty >= 4 AND p.IntProperty <> 6 AND EXISTS(103  SELECT TOP 1 1104  FROM dbo.DialogProcessChain c105    WITH(nolock)106  WHERE107    c.GenProcID = p.UID_SingleGuid AND c.ReadyForDeleteOrExport = 2)108  UPDATE @Worktable109  SET IntProperty = 0110  FROM @Worktable p111  WHERE112    p.IntProperty >= 4 AND EXISTS(113  SELECT TOP 1 1114  FROM dbo.JobHistory h115    WITH(nolock)116  WHERE117    h.GenProcID = p.UID_SingleGuid AND h.ReadyForDeleteOrExport IN(0, 1))118  UPDATE @Worktable119  SET IntProperty = 6120  FROM @Worktable p121  WHERE122    p.IntProperty >= 4 AND p.IntProperty <> 6 AND EXISTS(123  SELECT TOP 1 1124  FROM dbo.JobHistory h125    WITH(nolock)126  WHERE127    h.GenProcID = p.UID_SingleGuid AND h.ReadyForDeleteOrExport = 2)128  UPDATE @Worktable129  SET IntProperty = 1130  FROM @Worktable p131  WHERE132    p.IntProperty = 4133  UPDATE @Worktable134  SET IntProperty = 2135  FROM @Worktable p136  WHERE137    p.IntProperty = 6138  INSERT INTO @erg(GenProcID,139  ReadyForDeleteOrExport)140  SELECT141    w.UID_SingleGuid,142    w.IntProperty143  FROM @Worktable w144  WHERE145    w.IntProperty > 0146  RETURN147END
Open raw exported source
SQL ยท Raw22 lines
1create function dbo.QBM_FTDialogProcessReady (@ProcessesToCheck dbo.QBM_YSingleGUID readonly  ) returns @erg table( GenProcID varchar(38) collate database_default2 , ReadyForDeleteOrExport int default 0 ) as begin declare @Worktable dbo.QBM_YSingleGUID    insert into @Worktable(UID_SingleGuid  , IntProperty  ) select3 p.UID_SingleGuid , 4 from @ProcessesToCheck p  update @Worktable set IntProperty = 0  from @Worktable p where p.IntProperty = 4 and exists (select top4 1 1 from dbo.DialogDBQueue q with (nolock) where q.GenProcID = p.UID_SingleGuid   and q.Generation >= 0 )  update @Worktable set IntProperty = 0  from5 @Worktable p where p.IntProperty = 4 and exists (select top 1 1 from dbo.QBMDBQueueCurrent cu with (nolock) where cu.GenProcID = p.UID_SingleGuid  )  6update @Worktable set IntProperty = 0  from @Worktable p where p.IntProperty = 4 and exists (select top 1 1 from dbo.DialogDeferredOperation de with (nolock7) where de.GenProcID = p.UID_SingleGuid  )  update @Worktable set IntProperty = 0  from @Worktable p where p.IntProperty = 4 and exists (select top 1 18 from dbo.JobQueue q with (readpast) where q.GenProcID = p.UID_SingleGuid  ) if dbo.QBM_FGIModuleExists('QER') = 1 begin update @Worktable set IntProperty9 = 0  from @Worktable p where p.IntProperty = 4 and exists (select top 1 1 from dbo.PersonWantsOrg q with (readpast) where q.GenProcID = p.UID_SingleGuid10  ) end  update @Worktable set IntProperty = 0  from @Worktable p where p.IntProperty = 4 and exists (select top 1 1 from dbo.DialogWatchOperation w with11 (nolock) where w.GenProcID = p.UID_SingleGuid  and w.ReadyForDeleteOrExport in( 0, 1) )  update @Worktable set IntProperty = 6 from @Worktable p where12 IntProperty >= 4 and IntProperty <> 6 and exists (select top 1 1 from dbo.DialogWatchOperation w with (nolock) where w.GenProcID = p.UID_SingleGuid  and13 w.ReadyForDeleteOrExport = 2 )  update @Worktable set IntProperty = 0  from @Worktable p where p.IntProperty >= 4 and exists (select top 1 1 from dbo.DialogProcessChain14 c with (nolock) where c.GenProcID = p.UID_SingleGuid  and c.ReadyForDeleteOrExport in ( 0, 1) ) update @Worktable set IntProperty = 6 from @Worktable 15p where p.IntProperty >= 4 and p.IntProperty <> 6 and exists (select top 1 1 from dbo.DialogProcessChain c with (nolock) where c.GenProcID = p.UID_SingleGuid16  and c.ReadyForDeleteOrExport = 2 )  update @Worktable set IntProperty = 0  from @Worktable p where p.IntProperty >= 4 and exists (select top 1 1 from17 dbo.JobHistory h with (nolock) where h.GenProcID = p.UID_SingleGuid  and h.ReadyForDeleteOrExport in ( 0, 1) ) update @Worktable set IntProperty = 6 from18 @Worktable p where p.IntProperty >= 4 and p.IntProperty <> 6 and exists (select top 1 1 from dbo.JobHistory h with (nolock) where h.GenProcID = p.UID_SingleGuid19  and h.ReadyForDeleteOrExport = 2 )  update @Worktable set IntProperty = 1 from @Worktable p where p.IntProperty = 4 update @Worktable set IntProperty20 = 2  from @Worktable p where p.IntProperty = 6   insert into @erg (GenProcID, ReadyForDeleteOrExport) select w.UID_SingleGuid, w.IntProperty from @Worktable21 w where w.IntProperty > 0 return end 22