UFN_MKTSEGMENTATION_INCLUDEASKLADDERS

CREATE function dbo.[UFN_MKTSEGMENTATION_INCLUDEASKLADDERS]
(
  @SEGMENTATIONID uniqueidentifier
)
returns bit
as
begin
  declare @COUNT int;
  select @COUNT=count(*) from dbo.[MKTSEGMENTATIONSEGMENT] where [SEGMENTATIONID] = @SEGMENTATIONID and [ASKLADDERID] is not null;
  if @COUNT>0
    return 1
  else
    select @COUNT=count(*) from dbo.[MKTSEGMENTATIONTESTSEGMENT] inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID]=[MKTSEGMENTATIONSEGMENT].[ID] where [SEGMENTATIONID] = @SEGMENTATIONID and [MKTSEGMENTATIONTESTSEGMENT].[ASKLADDERID] is not null;                        

  if @COUNT>0
    return 1
  else
    select @COUNT=count(*) from dbo.[MKTSEGMENTATIONASKLADDEROVERRIDE] where [SEGMENTATIONID] = @SEGMENTATIONID ;                        

  if @COUNT>0
    return 1

  return 0;
end