UFN_PDACCOUNTSEGMENTMAP_TOITEMLISTXML

CREATE function dbo.UFN_PDACCOUNTSEGMENTMAP_TOITEMLISTXML(
    @ACCOUNTSTRUCTUREID uniqueidentifier
    )
returns xml
as
begin

return (
select * from (    
  select     
    mv.LONGDESCRIPTION as LONGDESCRIPTION
    ,mv.LONGDESCRIPTIONID as LONGDESCRIPTIONID
    ,m.PDACCOUNTSEGMENTVALUEID
  from dbo.PDACCOUNTSEGMENTMAPPINGVIEW as mv
  left outer join dbo.PDACCOUNTSEGMENTMAPPING as m 
    on mv.LONGDESCRIPTIONID = m.LONGDESCRIPTIONID and m.PDACCOUNTSTRUCTUREID = @ACCOUNTSTRUCTUREID  
  where mv.PDACCOUNTSTRUCTUREID = @ACCOUNTSTRUCTUREID
  union all 
   select
    m.LONGDESCRIPTION as LONGDESCRIPTION
    ,m.LONGDESCRIPTIONID as LONGDESCRIPTIONID
    ,m.PDACCOUNTSEGMENTVALUEID
  from 
  dbo.PDACCOUNTSEGMENTMAPPING as m 
  where m.PDACCOUNTSTRUCTUREID = @ACCOUNTSTRUCTUREID
  and m.LONGDESCRIPTION='<Not Used>'
) as SM  
order by 
    case LONGDESCRIPTION when '<Not Used>' then 0 else 1 end, LONGDESCRIPTION
  for xml raw('ITEM'),type,elements,root('PDACCOUNTSEGMENTMAP'),BINARY BASE64
);

end