I'm pretty sure your XML format is not actually valid XML.  I don't think you can repeat the same tag at the same level.

I recall that the original post wanted to add a CR/LF for each note.   This would make the report easier to deal with than having to adjust to not repeat...

Try this "CROSS TAB" query:WITH TABLE1 (PATIENT, ID) AS (

    SELECT 'PatientA', 1234 UNION ALL
    SELECT 'PatientB', 5678
),
    TABLE2 (ID, CODE, [VALUE]) AS (

        SELECT 1234, 'Code1',...

ALTER TABLE just doesn't work the way you might want it to, and if it did, would probably be far too dangerous.   ALTER TABLE has to have the specific column...

We need a lot more detail.   It appears likely that the data you have is not standard English characters, but just changing a datatype from varchar to nvarchar only provides...

Try this:DECLARE @DriverData AS TABLE (
    Drv int,
    DOW varchar(9),
    [Shift] varchar(13)
);
INSERT INTO @DriverData (Drv, DOW, [Shift])
    VALUES    (1, null, null),
            (2, 'Sunday', '06:00-12:00'),
            (2, 'Monday', '06:00 -11:00'),
            (2,...

Why are you trying to format the data within MDX?   SSRS is where that formatting needs to be.   Values coming from your MDX query that are actually dates instead of...