Back to OIM Explorer

dbo.QBM_ZViewBuildV

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.427 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVGUIDToModuleOwner source text reference
  • references source dbo.QBM_FGITableName source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PViewBuild source text reference
  • references source dbo.QBM_PViewBuildV source text reference
  • references source dbo.QBM_PViewBuildV_intern source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL69 lines
1CREATE PROCEDURE QBM_ZViewBuildV(2  @SlotNumber int,3  @UID_DialogTable_Param varchar(38),4  @dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @uid_dialogTable varchar(38)10  DECLARE @tableGUID QBM_YCursorBuffer11  DECLARE @ElementCount int12  DECLARE @ElementIndex int13  BEGIN TRY14    INSERT INTO @tableGUID(UID1)15    SELECT16      DISTINCT x.UID_DialogTable17    FROM(18    SELECT19      t.UID_DialogTable,20      def.SortOrder21    FROM DialogTable t22      WITH(readpast)23    JOIN QBMModuleDef def24      WITH(readpast)25      ON26    LEFT(t.uid_dialogtable, 3) = def.ModuleName27    WHERE28      t.UID_DialogTable = @UID_DialogTable_Param AND t.TableType = 'V'29    UNION30    SELECT31      @UID_DialogTable_Param,32      133    FROM INFORMATION_SCHEMA.TABLES t34      WITH(readpast)35    WHERE36      dbo.QBM_FGITableName(@UID_DialogTable_Param) = t.TABLE_NAME collate database_default AND t.TABLE_TYPE = 'VIEW') AS x37    ORDER BY x.UID_DialogTable38    SELECT @ElementCount = @@rowcount39    SELECT @ElementIndex = 140    WHILE @ElementIndex <= @ElementCount41    BEGIN42      SELECT TOP 1 @uid_dialogTable = bu.UID143      FROM @tableGUID bu44      WHERE45        bu.ElementIndex = @ElementIndex46      IF dbo.QBM_FCVGUIDToModuleOwner(@uid_dialogTable) = 'CCC'47      BEGIN48        EXEC QBM_PViewBuildV_intern @uid_dialogTable,49          @GenProcID,50          @AutoCorrectColumns = 151      END52      ELSE53      BEGIN54        EXEC QBM_PViewBuildV_intern @uid_dialogTable,55          @GenProcID56      END57      SELECT @ElementIndex += 158    END59  END TRY60  BEGIN CATCH61    EXEC QBM_PSessionErrorAdd DEFAULT62    RAISERROR('',63    18,64    1)65      WITH NOWAIT66  END CATCH67  ende:68  RETURN69END
Open raw exported source
SQL ยท Raw11 lines
1   create   procedure QBM_ZViewBuildV (@SlotNumber int , @UID_DialogTable_Param varchar(38) , @dummy varchar(38) , @GenProcID varchar(38) ) AS begin2 declare @uid_dialogTable varchar(38) declare @tableGUID QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int BEGIN TRY insert into @tableGUID3(UID1 ) select distinct x.UID_DialogTable from (           select t.UID_DialogTable, def.SortOrder from DialogTable t with (readpast) join QBMModuleDef4 def with (readpast) on LEFT(t.uid_dialogtable, 3) = def.ModuleName where t.UID_DialogTable = @UID_DialogTable_Param and t.TableType = 'V' union select5 @UID_DialogTable_Param, 1 from INFORMATION_SCHEMA.TABLES t with (readpast) where dbo.QBM_FGITableName(@UID_DialogTable_Param) = t.TABLE_NAME collate database_default6 and t.TABLE_TYPE = 'VIEW' ) as x order by  x.UID_DialogTable select @ElementCount = @@rowcount select @ElementIndex = 1 while @ElementIndex <= @ElementCount7 begin select top 1 @uid_dialogTable = bu.UID1  from @tableGUID bu where bu.ElementIndex = @ElementIndex if dbo.QBM_FCVGUIDToModuleOwner(@uid_dialogTable8) = 'CCC' begin exec QBM_PViewBuildV_intern @uid_dialogTable , @GenProcID , @AutoCorrectColumns = 1 end else begin exec QBM_PViewBuildV_intern @uid_dialogTable9 , @GenProcID end select @ElementIndex += 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende:10 return end 11