>>>>Hi,
>>>>
>>>>Can you see what is wrong with the following SQL Select that outputs into XML? The error I get (in the calling routine) that the XML has multiple root element. Another thing is that in the SQL Server query window the first name (USER_NAME) is shown in a different color (looks like purple).
>>>>
>>>>

>>>>SELECT USER_NAME "USER_NAME", USER_EMAIL "USER_EMAIL", USER_CC "USER_CC", 
>>>>USER_PHONE "USER_PHONE", USER_BLDG "USER_BLDG", USER_FLOOR "USER_FLOOR",
>>>>USER_ROOM "USER_ROOM" FROM USERINFO WHERE COOKIE_ID = @CookieId FOR XML PATH ('') 
>>>>

>>>>
>>>>TIA.
>>>
>>>USER_NAME is a function in SQL Server. Now, do you have a field making each row unique? If not, XML PATH is getting confused.
>>
>>The table has a PK field which makes each row/field unique. Do I understand correctly that the fact that one of the columns in the table has the same name as a function in SQL Server causes the error with "multiple root elements" ?
>
>No, this is not it. For now, remove all aliases (since they are the same as field names) and add that PK field to the query.

Adding ROOT('USERS') eleminated the error. But now my code that parses the XML fails. So I have to figure what is wrong with my code that loads XML (I am using xdoc.LoadXml( XmlFileString). Maybe I will have to start a new thread for that. Thank you.