Can you tell us what you would like the answer to be, for your example of 295, 3, 0?

One formula which avoids the problem is to calculate any two of...

I created a temp table and inserted your XML doc into it. The following code worked for me

SELECT ChannelId = v.n1.value('(.)[1]', 'INT')
FROM #SomeXML sx
   ...

You need to change the role memberships within MSDB. Untick everything except db_owner and try again.

Where is the DDL, sample data, desired results?

Merely providing a mass of unformatted code is not the way to get results, as you well know.

Please try renaming your XML file as .TXT and attaching again. Some file types are blocked.

Then I am out of ideas. Anyone else care to help?

You really can't see why?

If User X has 10 rows of data, each with a different 'created-at' value, which one of those values would you wish to return in the...

Thanks! One thing what if I need to add a field like [Date] (which I may want to do grouping on later)? It wants this added to the 'group...

Just to be clear, you executed only this part, is that correct?

EXEC msdb.dbo.sp_send_dbmail @profile_name = '***'
           ...

Try this

SELECT [user_name], SUM(dbo.fnGetDecimalTime([event_sec])) as 'Decimal_Time_SUM'
FROM [Charter].[dbo].[ConvoHrs]
group by [user_name]
order by [user_name]

You cannot group by a column (Decimal_Time) and then hope that it is ignored when the results...

Your query syntax is invalid.

SELECT * FROM dbo.View_rates

might work, but you should really

a) Test your query first, and

b) Explicitly name the columns that you wish to return

Try again after adding this to the command:

@query_result_header = 1,

You need to read the documentation a little more closely. You have not defined @query and your database name looks more like a table name.

I agree with Ken. With the addition of MeetingId, the problem seems trivial:

SELECT *
      ,Meeting_Id = ROW_NUMBER() OVER (ORDER BY d.StartDatePeriod)
FROM #dateresult...

Can you clarify what you mean by this part?

I "just" need to "unfold" the set based on the left and right date interval, i.e. something like subfield in Oracle which...