CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_STAGE_INDICES

      create procedure [BBDW].[CREATE_OR_DROP_FACT_PLANNEDGIFTDESIGNATION_STAGE_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_STAGE_INDICES]',16,10);

        if @CREATE_OR_DROP =1
        begin
        --create

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTSYSTEMID') = 0
              create index [IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION_STAGE]([PLANNEDGIFTSYSTEMID]) on [BBRPT_STAGEGROUP];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDIMID') = 0
              create index [IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDIMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION_STAGE]([PLANNEDGIFTDIMID]) on [BBRPT_STAGEGROUP];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDESIGNATIONSYSTEMID') = 0
            create nonclustered index [IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDESIGNATIONSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION_STAGE] ([PLANNEDGIFTDESIGNATIONSYSTEMID]) on [BBRPT_STAGEGROUP];

        end
        else
        begin
        --drop

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTSYSTEMID') = 1
              drop index [IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION_STAGE];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDIMID') = 1
              create index [IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDIMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION_STAGE]([PLANNEDGIFTDIMID]) on [BBRPT_STAGEGROUP];

          if  [BBDW].[UFN_INDEXEXISTS]('IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDESIGNATIONSYSTEMID') = 1
              drop index [IX_FACT_PLANNEDGIFTDESIGNATION_STAGE_PLANNEDGIFTDESIGNATIONSYSTEMID] on [BBDW].[FACT_PLANNEDGIFTDESIGNATION_STAGE];

        end;