T sql dose not work in SQlCompact


  • im useing a T Sql in SQlCompact database but it dose not work the function is stuff() that forgathering values in on cell this is the select Statement but it shows me an error asking for help

    SELECT Pepole.ID, Pepole.FNA, Pepole.LNA, STUFF ((SELECT ', ' + Name AS Expr1 FROM Special AS S2 WHERE (ID = PeopleTarget_1.SpecialID) FOR XML PATH('')),,,) AS Names FROM Pepole INNER JOIN PeopleTarget AS PeopleTarget_1 ON Pepole.ID = PeopleTarget_1.PeopleID INNER JOIN Special AS Special_1 ON PeopleTarget_1.PeopleID = Special_1.ID

    • Edited by Aboudeh Monday, April 07, 2014 7:33 AM
    Monday, April 07, 2014 7:18 AM