Hello,

So basically I have an SSIS package that fails when I use an older version of excel (xls). I cannot change the way the excel file is loaded since...

This seems a bit terse. What are you trying to achieve?

Note that many people (including me) choose not to open non-text attachments –...

Yup, I was one of the 'most people' crowd, thanks for alerting me to that, Jeff. Always good to be aware of these extra possibilities. It was also only recently...

We cannot give you a definitive answer, because we can't see your data or table structures. But the fact that each of the queries works individually, but not when joined,...

Wow, never even seen that function before, cool stuff, Steve.

Here is a quick solution. There will be more elegant ways, I'm sure:

DROP TABLE IF EXISTS #t;

CREATE TABLE #t
(
    Col1 CHAR(1) NULL
  ...

Are you hoping for some T-SQL, or are the suggestions already provided sufficient?

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