Thanks, Jeff. Truly appreciate your help with this!

--snip

I am just curious as to what procedure you will be using. I was digging around a bit and I came across...

Can you provide DDL and sample data for dbo.ConvoHrs, rather than asking people to use guesswork?

As TangoVictor mentions, there are other possibilities.

One is to keep the filename exactly as it is and instead modify your 'subsequent processing' tasks to use a variable file name. This...

In Excel, you see the incorrect...

SELECT ItemCode from T1 UNION SELECT ItemCode from T2

Thank you very much! If you have trouble getting this...

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