Yep, I am using SSMS. The setting is at max too. My problem is that this was working last week and returning the output to the xml_col without...

The script without the xml portion runs fine, as you noticed. However, with the xml portion, the script returns only the first record from the BETWEEN statement, and even...

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...

I'm a little confused. Is that data at the bottom of what I posted not appropriate? Also, I do not know how to convert the Text datatype to...

Sorry, does this help? Also, I followed the link that the other gentleman had for putting some data together.

[HPSITE].[DEMOGRAPHICS]

[IMREDEM_CODE] [int]

[DEM_EXTERNALID] [varchar]

[DEM_LASTNAME] [varchar]

[DEM_FIRSTNAME] [varchar]

[DEM_DATEOFBIRTH] [datetime]

[HPSITE].[CHARTATTACHMENT]

[IMREDEMEC_CODE] [int]

[IMRENOTE_CODE] [int]

[CHAT_DATE] [datetime]

[HPSITE].[NOTES_MASTER]

[IMRENOTE_CODE] [int]

[HPSITE].[NOTES_TEXTDATA]

[IMRENOTE_CODE] [int]

[NOTE_TEXT]...