When I ran your query, it said it couldn't find the table...
And you never defined what you mean by Margin. Without TotalCost, how do you define Margin?

Okay, Can you post some sample data and expected output? I'm still not clear on what you're trying to do.

Umm... that post you're adding to is SEVENTEEN YEARS old.
How about...
https://sqlwithmanoj.com/tag/bcp-queryout/

Using the above Cross Apply where we have 3 rows coming back, is there a way to tell it to only send only one row instead of three based on...

Is this an Access question or a SQL Server question? I'm asking because SQL Server uses single quotes to delimit text strings and Access uses double quotes. If you're writing...

(Shows how much I understand about FOR XML... is there a good book on the bare necessities you need to understand about XML in SQL Server?)

But you could create a table and write the values from the DMV into it... Then you could look at it over time. Not sure it's worth doing, but that's...

Use a TVF like DelimitedSplit8K to break out the pieces, sort them then reassemble using STUFF.

step 1: find all the names that are not null 
step 2: union them together.
insert the result from step 2 into your final table.
return results from final table....

How about
CREATE TABLE Meeting (
    MeetingID INT IDENTITY PRIMARY KEY,
    MeetingType VARCHAR(20) NOT NULL,
    StartDateTime DATETIME,
    EndDateTime DATETIME...)

And then...

A little normalization goes a long way. If a single record describes ONE meeting, then this is trivial.

Oh, right... funny, I totally forgot about Kenneth Fisher's example of using CROSS APPLY to unpivot. (See me still thinking in terms of Access??!! BLECH!!)

One way of doing it is like this:
(this is a sample bad table)
CREATE TABLE DiagnosesBad (
    PatientID INT NOT NULL,
    Cycle TINYINT NOT NULL,
    Diagnosis9_1 VARCHAR(20),