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
(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
Forgot to include the error message.
Invalid SELECT statement. Unexpected token “FOR” at line 1, pos 2498