UFN_PDCOMPOSITESEGMENTMAPPING_KEY

  create function [dbo].[UFN_PDCOMPOSITESEGMENTMAPPING_KEY] (@PDCompositeSegmentMappingID uniqueidentifier)
  returns nvarchar(144)
  as
  begin
  return (select (''+LONGDESCRIPTIONID)
  from dbo.PDCOMPOSITESEGMENTMAPPINGENTRY t1 inner join dbo.PDCOMPOSITESEGMENTTABLELIST t2 on t1.PDCOMPOSITESEGMENTTABLELISTID = t2.ID
  where t1.PDCOMPOSITESEGMENTMAPPINGID = @PDCompositeSegmentMappingID
  order by t2.SEQUENCE
  for xml path( '' ))
  end