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...

The CSVs were created from Excel. I just save as CSV. I am guessing they are tabbed (they do appear in a table format)

The tables do contain confidential information...

Also try this version, which is the way I would usually do it.

SELECT * FROM #t t
WHERE NOT EXISTS (SELECT * from #t t2 where t2.status =...

Hmmm, calling that a solution is rather generous. It may make things work in your case, but storing a datetime in a...

I have a table which stores shipment data by date. We have a need to get last 52 weeks Shipments by week.

If today is 11/29/2021, My first week should...