SQL doesn't accept FOR XML PATH syntax...

leeWozyWarren · February 15th, 2012, 09:14 AM

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