UFN_MARKETINGEFFORTPERFORMANCE_USECOSTTOACQUIRE

create function dbo.UFN_MARKETINGEFFORTPERFORMANCE_USECOSTTOACQUIRE
(
@ID uniqueidentifier
)
returns bit
as 
begin
  declare @USECOSTTOACQUIRE bit = 0;
  if exists(select 'x' from dbo.MKTSEGMENTATIONSEGMENT inner join dbo.MKTSEGMENT on MKTSEGMENT.ID = MKTSEGMENTATIONSEGMENT.SEGMENTID
            where MKTSEGMENTATIONSEGMENT.SEGMENTATIONID = @ID and MKTSEGMENT.SEGMENTTYPECODE = 2)     
    set @USECOSTTOACQUIRE = 1      

  return @USECOSTTOACQUIRE
end