I am using Management Studio 2008 and trying to write a query using FOR XML PATH. But the the word PATH is throwing an error! Here is my code:
SELECT Id, Name AS "Submitters Name", SubmissionDate AS 'Submission Date', Book, ChangeName AS 'Change Name', ModificationChange AS 'Modification / Change', Priority, Month
The error is throws is here:
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near 'PATH'.
ANy thoughts as to why? I am using the book MSSQL Server 2008 Programming and this uses the code above. So why doesn't it work on my MSSQL MS?