;WITH ARNOTES

as (

select * from [myTable0914]

UNION ALL

select * from [myTable1014]

UNION ALL

select * from [myTable1114]

UNION ALL

select * from [myTable1214])

Select ARNOTES.AR_NUMBER,HD_DATE_TIMEX,ARNOTES.TRANS_NO,ARNOTES.MESSAGE_COUNTER,

rtrim(ltrim(ARNOTES.Message_2)) as Notes,

DATEDIFF(day, HD_DATE_TIMEX, GETDATE()) as daysoldIND

,( SELECT rtrim(ltrim(ARNOTES.Message_2)) + ' ' as [text()]

FROM ARNOTES

FOR XML PATH ('')) as Notes,

ARNOTES.SQL_LAST_UPDATE

from ARNOTES

GROUP By ARNOTES.AR_NUMBER,HD_DATE_TIMEX,ARNOTES.TRANS_NO,ARNOTES.MESSAGE_COUNTER,ARNOTES.Message_2,ARNOTES.SQL_LAST_UPDATE