Hi guys,
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:
Code:
SELECT Id, Name AS "Submitters Name", SubmissionDate AS 'Submission Date', Book, ChangeName AS 'Change Name', ModificationChange AS 'Modification / Change', Priority, Month
FROM [dbo].[ChangeRequest]
FOR
XML PATH
The error is throws is here:
Code:
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?
Best
Lee
SQL doesn't accept FOR XML PATH syntax...
Linear Mode
