T-sql Common expression query as subquery

Question

I have the following query:

    WITH Orders(Id)
AS (
SELECT DISTINCT anfrageid FROM MPHotlineAnfrageAnhang
)
SELECT Id,
(
SELECT CONVERT(VARCHAR(255),anfragetext) + ' | '
FROM MPHotlineAnfrageAnhang
WHERE anfrageid = Id
ORDER BY anfrageid, erstelltam
FOR XML PATH('')
) AS Descriptions
FROM Orders

Its concatenates varchar values of diferents rows grouped by an id. But now i want to include it as a subquery and it gives some errors i cant solve. Simplified example of use:

select descriptions from 
(
    WITH Orders(Id)
    AS (
    SELECT DISTINCT anfrageid FROM MPHotlineAnfrageAnhang
    )
    SELECT Id,
    (
    SELECT CONVERT(VARCHAR(255),anfragetext) + ' | '
    FROM MPHotlineAnfrageAnhang
    WHERE anfrageid = Id
    ORDER BY anfrageid, erstelltam
    FOR XML PATH('')
    ) AS Descriptions
    FROM Orders
) as tx where id=100012

Errors (Aproximate translation from spanish):

-Incorrect sintaxis near 'WITH'.
-Incorrect sintaxis near 'WITH'. If the instruction is a common table expression or a xmlnamespaces clause, the previous instruction must end with semicolon.
-Incorrect sintaxis near ')'.

What im doing wrong?

Answer 1

Chain your queries as CTEs, like this:

WITH Orders(Id) AS (
    SELECT DISTINCT anfrageid
    FROM MPHotlineAnfrageAnhang
),
OrderDescs AS (
    SELECT Id, (
        SELECT CONVERT(VARCHAR(255),anfragetext) + ' | '
        FROM MPHotlineAnfrageAnhang
        WHERE anfrageid = Id
        ORDER BY anfrageid, erstelltam
        FOR XML PATH('')
        ) AS Description
    FROM Orders
)
SELECT Description
FROM OrderDescs
WHERE Id = 100012 

You can have as many CTEs as you like, each referencing the previous, before the actual query.

Answer 2

Also, you need to have a semi-colon before a WITH statement.

;with Orders(id)

Or terminate the previous statement with the semi-colon instead.