SQL Syntax doesn't work in MS 2008

leeWozyWarren · February 15th, 2012, 09:09 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

irProject · February 18th, 2012, 02:53 AM

Hi there.

xml tags can't contain spaces.

try this one:

Code:

SELECT Id, Name AS [SubmittersName], SubmissionDate AS [SubmissionDate], Book, ChangeName AS [ChangeName], ModificationChange AS [ModificationOrChange], Priority, Month

FROM [dbo].[ChangeRequest]
  FOR XML PATH

irProject · February 18th, 2012, 02:55 AM

Hi again

see the following link:

http://geekswithblogs.net/chavansach...30/112132.aspx

leeWozyWarren · February 18th, 2012, 05:02 PM

Thanks so much for the advice. It works now. So simple an answer too! Cheers!

Lee