something like this maybe?
SELECT
tranid,
(
SELECT OriginCode + DestinationCode
FROM #test p2
WHERE p1.tranid = p2.tranid
FOR XML PATH('')
)
FROM #test p1
GROUP BY tranid
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day