Back to OIM Explorer

dbo.QBM_FCVObjectKeyMNToParentKey

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.597 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_FCVElementToObjectKey1 source text reference
references source dbo.QBM_FCVObjectkeyToElement source text reference

References

Referenced By

dbo.QER_ZITShopMakeDecisionRI

Complete Source

1CREATE FUNCTION dbo.QBM_FCVObjectKeyMNToParentKey(2  @ObjectKeyMNTable varchar(138),3  @ParentDirection BIT4) RETURNS varchar(1385)6AS7BEGIN8  DECLARE @erg varchar(138) = NULL9  DECLARE @TableName varchar(30)10  DECLARE @ColumnName varchar(30)11  DECLARE @ParentTable varchar(30)12  DECLARE @ParentColumn varchar(30)13  DECLARE @ColumnValue varchar(38)14  SELECT15    @TableName = dbo.QBM_FCVObjectkeyToElement('TableName',16    @ObjectKeyMNTable)17  IF @ParentDirection = 018  BEGIN19    SELECT20      @ColumnName = dbo.QBM_FCVObjectkeyToElement('Columnname1',21      @ObjectKeyMNTable)22    SELECT23      @ColumnValue = dbo.QBM_FCVObjectkeyToElement('ColumnValue1',24      @ObjectKeyMNTable)25  END26  ELSE27  BEGIN28    SELECT29      @ColumnName = dbo.QBM_FCVObjectkeyToElement('Columnname2',30      @ObjectKeyMNTable)31    SELECT32      @ColumnValue = dbo.QBM_FCVObjectkeyToElement('ColumnValue2',33      @ObjectKeyMNTable)34  END35  IF @TableName > ' ' AND @ColumnName > ' ' AND @ColumnValue > ' '36  BEGIN37    SELECT38      TOP 1 @ParentTable = tp.TableName,39      @ParentColumn = cp.ColumnName40    FROM QBMRelation r41      WITH(readpast)42    JOIN DialogColumn cc43      WITH(readpast)44      ON r.UID_ChildColumn = cc.UID_DialogColumn45    JOIN DialogTable tc46      WITH(readpast)47      ON cc.UID_DialogTable = tc.UID_DialogTable48    JOIN DialogColumn cp49      WITH(readpast)50      ON r.UID_ParentColumn = cp.UID_DialogColumn51    JOIN DialogTable tp52      WITH(readpast)53      ON cp.UID_DialogTable= tp.UID_DialogTable54    WHERE55      tc.TableName = @TableName AND cc.ColumnName = @ColumnName AND r.IsMNRelation = 156    IF @ParentTable > ' ' AND @ParentColumn > ' '57    BEGIN58      SELECT59        @erg = dbo.QBM_FCVElementToObjectKey1(@ParentTable,60        @ParentColumn,61        @ColumnValue)62    END63  END64  endLabel:65  RETURN(@erg)66END

Open raw exported source

1    create   function dbo.QBM_FCVObjectKeyMNToParentKey(@ObjectKeyMNTable varchar(138) , @ParentDirection bit   ) returns varchar(138) as begin 2declare @erg varchar(138) = null declare @TableName varchar(30) declare @ColumnName varchar(30) declare @ParentTable varchar(30) declare @ParentColumn 3varchar(30) declare @ColumnValue varchar(38) select @TableName = dbo.QBM_FCVObjectkeyToElement('TableName', @ObjectKeyMNTable) if @ParentDirection = 0 4 begin select @ColumnName = dbo.QBM_FCVObjectkeyToElement('Columnname1', @ObjectKeyMNTable) select @ColumnValue = dbo.QBM_FCVObjectkeyToElement('ColumnValue1'5, @ObjectKeyMNTable) end else begin select @ColumnName = dbo.QBM_FCVObjectkeyToElement('Columnname2', @ObjectKeyMNTable) select @ColumnValue = dbo.QBM_FCVObjectkeyToElement6('ColumnValue2', @ObjectKeyMNTable) end if @TableName > ' ' and @ColumnName > ' ' and @ColumnValue > ' ' begin select top 1 @ParentTable = tp.TableName7 , @ParentColumn = cp.ColumnName from QBMRelation r with (readpast) join DialogColumn cc with (readpast) on r.UID_ChildColumn = cc.UID_DialogColumn join8 DialogTable tc with (readpast) on cc.UID_DialogTable = tc.UID_DialogTable join DialogColumn cp with (readpast) on r.UID_ParentColumn = cp.UID_DialogColumn9 join DialogTable tp with (readpast) on cp.UID_DialogTable= tp.UID_DialogTable where tc.TableName = @TableName and cc.ColumnName = @ColumnName and r.IsMNRelation10 = 1 if @ParentTable > ' ' and @ParentColumn > ' ' begin select @erg = dbo.QBM_FCVElementToObjectKey1(@ParentTable, @ParentColumn, @ColumnValue) end end11 endLabel: return(@erg) end 12