duh, I figured it out, but I can't delete my own post sorry
I'm trying to use the XML concatination trick in a query. but, I'm getting this error:
SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
how/where can I see and change the 'QUOTED_IDENTIFIER' setting for this table?
duh, i figured it out. I had
SET QUOTED_IDENTIFIER OFF
running before my query