Back to OIM Explorer

dbo.DPR_FTGetColsHandledByWorkflow

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 812 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

  • No direct source references extracted.

Complete Source

SQL35 lines
1CREATE FUNCTION dbo.DPR_FTGetColsHandledByWorkflow(2  @TableName varchar(30),3  @UID_Config varchar(38)4) RETURNS @erg TABLE(ColumnName varchar(30) collate database_default,5UID_DialogColumn varchar(38) collate database_default6)7AS8BEGIN9  DECLARE @merk QBM_YParameterlist10  INSERT INTO @merk(Parameter1,11  Parameter2)12  SELECT13    h.PropertyName,14    h.UIDConfig15  FROM DPR_VWorkflowHandlesProperty h16  WHERE17    h.SystemType = N 'OneIM' AND h.SchemaTypeName = @TableName AND h.UIDConfig = @UID_Config18  GROUP BY h.PropertyName,19  h.UIDConfig20  INSERT INTO @erg(ColumnName,21  UID_DialogColumn)22  SELECT23    c.ColumnName,24    c.UID_DialogColumn25  FROM DialogColumn c26    WITH(readpast)27  JOIN DialogTable t28    WITH(readpast)29    ON c.UID_DialogTable = t.UID_DialogTable30  JOIN @merk m31    ON c.ColumnName = m.Parameter132  WHERE33    t.TableName = @TableName34  RETURN35END
Open raw exported source
SQL ยท Raw7 lines
1create function dbo.DPR_FTGetColsHandledByWorkflow(@TableName varchar(30) , @UID_Config varchar(38) ) returns @erg table(ColumnName varchar(30) collate2 database_default , UID_DialogColumn varchar(38) collate database_default ) as begin declare @merk QBM_YParameterlist insert into @merk(Parameter1, Parameter23) select h.PropertyName  , h.UIDConfig from DPR_VWorkflowHandlesProperty h where h.SystemType = N'OneIM' and h.SchemaTypeName = @TableName and h.UIDConfig4 = @UID_Config group by h.PropertyName, h.UIDConfig insert into @erg(ColumnName, UID_DialogColumn) select c.ColumnName, c.UID_DialogColumn from DialogColumn5 c with (readpast) join DialogTable t with (readpast) on c.UID_DialogTable = t.UID_DialogTable join @merk m on c.ColumnName = m.Parameter1 where t.TableName6 = @TableName return end 7