USP_MKTSEGMENTATIONREFRESHPROCESS_GETOPTIONS

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

  declare @USECHECKDIGIT bit;
  declare @LASTFINDERNUMBER bigint;

  select
    @USECHECKDIGIT = [CHECKDIGIT],
    @LASTFINDERNUMBER = [LAST_FINDERNUMBER]
  from dbo.[MKTFINDERNUMBER];

  select 
    [MKTSEGMENTATION].[ID] as [SEGMENTATIONID],
    [MKTSEGMENTATION].[MAILINGTYPECODE],
    dbo.[UFN_MKTSEGMENTATIONACTIVATE_GETDONORIDDATATYPE]([MKTSEGMENTATION].[ID]) as [DONORIDDATATYPE],
    @USECHECKDIGIT as [USECHECKDIGIT],
    @LASTFINDERNUMBER as [LASTFINDERNUMBER],
    [MKTSEGMENTATION].[BASECURRENCYID]
  from dbo.[MKTSEGMENTATIONREFRESHPROCESS]
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONREFRESHPROCESS].[SEGMENTATIONID]
  where [MKTSEGMENTATIONREFRESHPROCESS].[ID] = @ID;

  return 0;