I was trying to execute this query,but it is showing the error as below
row name ' ' contains an invalid xml identifier as required by for xml in a query
Please help me out anyone if you can?
select ex1.[comet_organization],
ex1.[Company],
ex1.[Address1],
ex1.[street_number],
ex1.[first_name],
acconumber = REPLACE ( ( SELECT acconumber AS [text()]
FROM sl_cdce_cim_daily_customer_extract EX2
WHERE EX2.[first_name] = EX1.[first_name]
Go to the complete details ...