This what I have. Also, I am a little leary to alter the data type...remember the whole 'newbie' thing.

HPSITE.DEMOGRAPHICS

EID,IMREDEM_CODE,LN,FN,DOB

SELECT '2','4','LN4','FN4','Mar 18 1983 12:00AM'

SELECT '5','7','LN7','FN7','Feb 6 1996 12:00AM'

SELECT '8','10','LN8','FN8','Feb 15 1957 12:00AM'

SELECT '20','22','LN9','FN9','Jun 9 1971 12:00AM'

SELECT '25','27','LN10','FN10','Jul 22 1996 12:00AM'

SELECT '28','30','LN11','FN11','Apr 13 1993 12:00AM'

HPSITE.CHARTATTACHMENT

IMREDEMEC_CODE,IMRENOTE_CODE,CHAT_DATE

SELECT '2','146669','Feb 3 2005 1:34PM'

SELECT '2','146720','Feb 3 2005 2:00PM'

SELECT '2','146955','Feb 3 2005 3:47PM'

SELECT '2','147394','Feb 4 2005 8:37AM'

SELECT '2','591108','Mar 8 2006 2:09PM'

SELECT '2','2589211','Mar 24 2011 12:37PM'

SELECT '5','863598','Oct 9 2006 12:47PM'

SELECT '5','2322272','Jun 17 2010 2:49PM'

SELECT '5','2781700','Oct 24 2011 4:56PM'

SELECT '7','104338','Dec 23 2004 11:28AM'

SELECT '8','667930','May 9 2006 2:13PM'

SELECT '8','879185','Oct 20 2006 8:41AM'

SELECT '8','2203832','Feb 17 2010 2:12PM'

SELECT '8','2322216','Jun 17 2010 2:29PM'

SELECT '20','1490261','Feb 19 2008 8:03PM'

SELECT '20','1783630','Jan 5 2009 11:03AM'

SELECT '20','2380446','Aug 18 2010 11:05AM'

SELECT '20','2490167','Dec 6 2010 1:21PM'

SELECT '25','120797','Jan 11 2005 7:19AM'

HPSITE.NOTES_TEXTDATA

IMRENOTE_CODE, NOTE_TEXT

SELECT '146669',Text1

SELECT '146720',Text2

SELECT '146955',Text3

SELECT '147394',Text4

SELECT '591108',Text5

SELECT ''2589211',Text6

SELECT '863598',Text7

SELECT '2322272',Text8

SELECT '2781700',Text9

SELECT '104338',Text10

SELECT '667930',Text11

SELECT '879185',Text12

SELECT '2203832',Text13

SELECT '2322216',Text14

SELECT '1490261',Text15

SELECT '1783630',Text16

SELECT '2380446',Text17

SELECT '2490167',Text18

SELECT '120797',Text19

This is the code again, I realized that I had an extra Inner Join.

SELECT(

SELECT ROW_NUMBER() OVER(ORDER BY DEM_EXTERNALID) AS '@id', DEM_EXTERNALID, IMREDEM_CODE, DEM_LASTNAME, DEM_LASTNAME, DEM_DATEOFBIRTH,IMREDEMEC_CODE,CHAT_DATE,NOTE_TEXT

FROM HPSITE.DEMOGRAPHICS

INNER JOIN HPSITE.CHARTATTACHMENT ON HPSITE.DEMOGRAPHICS.IMREDEM_CODE = HPSITE.CHARTATTACHMENT.IMREDEMEC_CODE

INNER JOIN HPSITE.NOTES_TEXTDATA ON HPSITE.CHARTATTACHMENT.IMRENOTE_CODE = HPSITE.NOTES_TEXTDATA.IMRENOTE_CODE

WHERE IMREDEMEC_CODE BETWEEN '1' AND '10'

AND DEM_LASTNAME <>'Demonstration'

AND DEM_LASTNAME <>'Test'

AND DEM_LASTNAME <>'Train'

AND DEM_LASTNAME <>'Erroneous'

FOR XML PATH('Row'), ROOT('Results'), ELEMENTS XSINIL

) AS COL_XML;