USP_DATAFORMTEMPLATE_VIEW_EMAILPROCESS_SCHEDULE_1

        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EMAILPROCESS_SCHEDULE_1
        (
            @DATALOADED bit = 0 output,
          @STATUSENABLED bit = null output,
          @GENERALPURPOSEENABLED bit = null output,
            @TRANSACTIONALENABLED bit = null output
        )
        as
            set nocount on;

            -- be sure to set this, in case the select returns no rows
            set @DATALOADED = 1;

          set @TRANSACTIONALENABLED = ISNULL((select 1 from dbo.SCHEDULE S
                                inner join dbo.BUSINESSPROCESSSCHEDULE BPS on BPS.SCHEDULEID = S.ID
                            inner join dbo.GLOBALCHANGE GC on BPS.BUSINESSPROCESSPARAMETERSETID = GC.ID
                            where GC.GLOBALCHANGECATALOGID = 'F79575E5-FE4F-47BD-954C-AB056EF109D9' and S.ENABLED = 1),0)

          set @GENERALPURPOSEENABLED = ISNULL((select 1 from dbo.SCHEDULE S
                                inner join dbo.BUSINESSPROCESSSCHEDULE BPS on BPS.SCHEDULEID = S.ID
                            inner join dbo.GLOBALCHANGE GC on BPS.BUSINESSPROCESSPARAMETERSETID = GC.ID
                            where GC.GLOBALCHANGECATALOGID = '5066A489-6282-400C-96AF-1ECC1B7F281F' and S.ENABLED = 1),0)

          set @STATUSENABLED = ISNULL((select 1 from dbo.SCHEDULE S
                                inner join dbo.BUSINESSPROCESSSCHEDULE BPS on BPS.SCHEDULEID = S.ID
                            inner join dbo.GLOBALCHANGE GC on BPS.BUSINESSPROCESSPARAMETERSETID = GC.ID
                            where GC.GLOBALCHANGECATALOGID = '8C3ECDB1-BE50-4898-AD1B-98ECB6D07812' and S.ENABLED = 1),0)                          

            return 0;