UFN_CATEGORYDEFINITION

CREATE function dbo.UFN_CATEGORYDEFINITION()
returns table
as return
 select 
        T1.ID, 
        FROMCODE,
        TOCODE, 
        CATEGORYCODE,
        SUBCATEGORYCODE,
        NORMALBALANCE,
        NORMALBALANCECODE,
    PDACCOUNTSYSTEMID,
    (select case COUNT(1) when 0 then 0 else 1 end from dbo.PDACCOUNTSEGMENTVALUE where PDACCOUNTSEGMENTVALUE.TYPECODE = 1 and PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION between T1.FROMCODE and T1.TOCODE ) as ISINUSE

  from 
        dbo.CATEGORYDEFINITION T1