Home Forums SQL Server 2008 T-SQL (SS2K8) The FOR XML clause is invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. RE: The FOR XML clause is invalid in views, inline functions, derived tables, and subqueries when they contain a set operator.

  • March 19, 2013 at 1:30 am

    #1598311

    be aware that by using an External Select Statement we are going to have an Extra tag being added in the XML File. So we have to take care of the XML Consumption Process accordingly.

    Regards,

    Patibandla.