USP_MKTSEGMENTATION_CHECKACTIVATION

CREATE procedure dbo.[USP_MKTSEGMENTATION_CHECKACTIVATION]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  if (select [ACTIVE] from dbo.[MKTSEGMENTATION] where [ID] = @ID) = 1
    begin
      raiserror('The marketing effort has already been activated and no changes can be made.', 13, 1);
      return 1;
    end

  if dbo.[UFN_MKTSEGMENTATION_ISACTIVATING](@ID) = 1
    begin
      raiserror('The marketing effort is currently being activated and no changes can be made.', 13, 1);
      return 1;
    end

  return 0;