It seems you have used double quote
" instead of two single qoutes''. check updating your query with new query as shown below
your query :
SELECT STUFF((SELECT ',' + scd_service_id FROM Service_Details FOR XML PATH(")),1,2,")
new query :
SELECT STUFF((SELECT ',' + scd_service_id FROM Service_Details FOR XML PATH('')),1,2,'')