|
|
Posted by jonathaneggert on 11/10/06 07:54
The following seems to work in SQL Server 2005, but I'm getting the
error 'Incorrect syntax near xml' when I run it in SQL Server 2000.
select a.accountid , (select street, city, state, zip from account b
where a.accountid =b.accountid for xml auto, elements) as xmldata
from account a
The idea is to return 2 columns:
accountid
xmldata (address as xml)
Assuming the fields are correct, any ideas on what the problem might be?
Navigation:
[Reply to this message]
|