Print ''
Print '---------------------------------------------------------------------------------------'
Print ' using Database: #DB_N#'
Print ' Procedures    : [REPORTS Customer GB]'
Print ' Creation      : 29.09.2022/J.Fes'

use [#DB_N#]
   -- JobMgr_30_ApplProceduresReports03_ListOfResults.sql
--------------------------------------------------------------------------------
Print '-- [Report_910_GB_ListEmptyObjectCLIName] --------------------------------------'
If Exists (select Name from sysobjects where type = "P" and
           Name = "Report_910_GB_ListEmptyObjectCLIName")
Drop Procedure Report_910_GB_ListEmptyObjectCLIName
GO
CREATE PROCEDURE Report_910_GB_ListEmptyObjectCLIName
       (
        @ObjectFromSiteID nvarchar(32) ,
        @ProcStateCol nvarchar(14),
        @ObjectClass nvarchar(10)
       )


AS
begin
SELECT ObjectName,
       ObjectName2,
       ObjectClass
FROM dbo.Objects_tbl
  WHERE
      ObjectClass = @ObjectClass
  and ObjectFromSiteID = @ObjectFromSiteID
  and ObjectCLIName = ''

end
GO

Print ''
Print '---------------------------------------------------------------------------------------'
Print ' R E P O R T S imported to #DB_N#'
Print '---------------------------------------------------------------------------------------'
GO
