UFN_BANKACCOUNTADJUSTMENT_GETUNMAPPEDCOMPOSITESEGMENT

CREATE function dbo.UFN_BANKACCOUNTADJUSTMENT_GETUNMAPPEDCOMPOSITESEGMENT()
returns nvarchar(10)
with execute as caller
as begin
    declare @BadFlag bit

if exists (select V1.ID, V3.ID
      from
      (select t1.id, count(*) as TableCount
      from pdaccountstructure t1 inner join pdaccounttablesavailableforsegment t2 on t1.pdaccounttablesavailableforsegmentid = t2.id
      inner join pdcompositesegmenttablelist t3 on t2.tableid = t3.pdcompositesegmentid
      where t1.segmenttype = 4
      group by t1.id) V1
      full outer join
      (select V2.ID, MAX(V2.SegmentCount) as SegmentCount
      from
              (select t1.id, count(*) as SegmentCount
              from pdaccountstructure t1 inner join pdcompositesegmentmapping t2 on t1.id = t2.pdaccountstructureid
              inner join pdcompositesegmentmappingentry t3 on t2.id = t3.pdcompositesegmentmappingid and t3.isdefault = 1
              where t1.segmenttype = 4
              group by t1.id, t3.PDCompositeSegmentMappingID) V2
              group by V2.ID) V3
      on V1.ID = V3.ID
      where isnull(TableCount,0) != isnull(SegmentCount,0))
      set @BadFlag = 1
else
      set @BadFlag = 0
    return @BadFlag
end