UFN_MKTSEGMENTATION_GETCACHEDRECORDCOUNT

CREATE function dbo.[UFN_MKTSEGMENTATION_GETCACHEDRECORDCOUNT]
(
  @SEGMENTATIONID uniqueidentifier
)
returns integer
as
begin
  declare @RECORDCOUNT integer = 0;

  select
    @RECORDCOUNT = sum(isnull([MKTSEGMENTATIONSEGMENTCACHEINFO].[OFFERCOUNT], 0))
  from dbo.[MKTSEGMENTATIONSEGMENTCACHEINFO]
  inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENTCACHEINFO].[SEGMENTID]
  where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID;

  return @RECORDCOUNT;
end