Back to OIM Explorer

dbo.QBM_FGIDBQueueDeflateUsefull

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 554 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_FGITableCountAll source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL23 lines
1CREATE FUNCTION dbo.QBM_FGIDBQueueDeflateUsefull(2) RETURNS BIT3AS4BEGIN5  RETURN(CASE6  WHEN EXISTS(7  SELECT TOP 1 18  FROM(9  SELECT10    (dbo.QBM_FGITableCountAll('DialogDBQueue')) AS alles,(11  SELECT count(*) AS anzahl12  FROM(13  SELECT14    max(q.UID_DialogDBQueue) AS UID_DialogDBQueue, q.UID_Task, q.Object, q.SubObject, q.GenProcID15  FROM DialogDBQueue q16    WITH(readpast)17  GROUP BY q.UID_Task, q.Object, q.SubObject, q.GenProcID) AS x) AS komprimiert) AS y18  WHERE19    y.alles > 1500000 AND y.alles * 0.80 > y.komprimiert) THEN20  121  ELSE 022  END)23END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QBM_FGIDBQueueDeflateUsefull(    ) returns bit as begin return ( case when exists (select top 1 1 from ( select (dbo.QBM_FGITableCountAll2('DialogDBQueue')) as alles, (select count(*) as anzahl from ( select max(q.UID_DialogDBQueue) as UID_DialogDBQueue, q.UID_Task, q.Object, q.SubObject,3 q.GenProcID  from DialogDBQueue q with (readpast) group by q.UID_Task, q.Object, q.SubObject, q.GenProcID ) as x ) as komprimiert ) as y where  y.alles4 > 1500000  and y.alles * 0.80 > y.komprimiert          ) then 1 else 0 end ) end 5