how to solve parse error?

• saskee

  SSC Rookie

  Points: 32

  More actions

  November 21, 2021 at 9:42 am

  #3955290

  here is my code for parse data but here I have error like this 'StoreSurvey' has fewer columns than were specified in the column list.'

  what I have to do?

  '''

  WITH XMLNAMESPACES(

  'http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey'

  AS XM)

  SELECT SalesPersonID,

  StoreSurvey.AnnualSales.value('(XM:AnnualSales)','INT') as AnnualSales,

  StoreSurvey.AnnualRevenue.value('(XM:AnnualRevenue)','INT') as AnnualRevenue

  FROM Sales.Store

  CROSS APPLY Demographics.nodes('//XM:StoreSurvey') as

  StoreSurvey(AnnualSales,AnnualRevenue)

  '''

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  November 22, 2021 at 10:10 am

  #3955529

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• December 14, 2021 at 5:38 am

  This was removed by the editor as SPAM