CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_INDICES

      create procedure [BBDW].[CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_INDICES]
        @CREATE_OR_DROP bit --1 to create, 0 to drop.
      as
        set nocount on;

        if @CREATE_OR_DROP is null
          raiserror('@CREATE_OR_DROP must be 1 or 0 in [BBDW].[CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_INDICES]',16,10);

        if @CREATE_OR_DROP =1
        begin
          --create

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONSYSTEMID') = 0
            create index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION]([PLANNEDGIFTDESIGNATIONSYSTEMID]) on [BBRPT_FACTIDXGROUP];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONFACTID') = 0
            create index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONFACTID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION]([PLANNEDGIFTDESIGNATIONFACTID]) on [BBRPT_FACTIDXGROUP];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTSYSTEMID') = 0
            create index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION]([PLANNEDGIFTSYSTEMID]) on [BBRPT_FACTIDXGROUP];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDIMID') = 0
            create index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDIMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION]([PLANNEDGIFTDIMID]) on [BBRPT_FACTIDXGROUP];

        end
        else
        begin
          --drop

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONSYSTEMID') = 1
            drop index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONFACTID') = 1
            drop index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDESIGNATIONFACTID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTSYSTEMID') = 1
            drop index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDIMID') = 1
            drop index [IX_FACT_PLANNEDGIFTDESIGNATION_PLANNEDGIFTDIMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION];

        end