Skip to content


Add designer support SQL keyword FOR XML

Jason Halvorson asked 5 years ago
 When I include this FOR XML PATH statement, the designer errors out and then I can’t access the map’s designer view.

(SELECTDISTINCT ‘, ‘ + Cast(sc_sequence AS VARCHAR(10))
FROM   dbo.sc_gen_parts_ship_log_part_tracking_ongoing_etech_jobs_to_wow
WHERE  sc_processed = 0
FOR xml path()), 1, 1, ) AS CSV

Jason replied 5 years ago

Forgot to include the error message.

Invalid SELECT statement. Unexpected token “FOR” at line 1, pos 2498

If you would like to submit an answer or comment, please sign in to the eOne portal.