USP_MKTSEGMENTGROUPREFRESHPROCESS_GETOPTIONS

create procedure dbo.[USP_MKTSEGMENTGROUPREFRESHPROCESS_GETOPTIONS]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select 
    [MKTSEGMENTGROUPREFRESHPROCESS].[SEGMENTGROUPID],
    [MKTSEGMENTGROUP].[NAME] as [SEGMENTGROUPNAME],
    [MKTSEGMENTGROUP].[SEGMENTFAMILYTYPECODE],
    (select count([ID]) from dbo.[MKTGROUPSEGMENTS] where [SEGMENTGROUPID] = [MKTSEGMENTGROUP].[ID]) as [SEGMENTCOUNT]
  from dbo.[MKTSEGMENTGROUPREFRESHPROCESS]
  inner join dbo.[MKTSEGMENTGROUP] on [MKTSEGMENTGROUP].[ID] = [MKTSEGMENTGROUPREFRESHPROCESS].[SEGMENTGROUPID]
  where [MKTSEGMENTGROUPREFRESHPROCESS].[ID] = @ID;

  return 0;