The standard behavior for concatenation of strings is that if one of the strings to be concatenated is a null the concatenated string will also be null.

You can change this...

select
PartId,
FeatureName,
Status,
case when exists (
select * from #parts 
where PartId=p.PartId 
and FeatureName=p.FeatureName 
group by PartId, FeatureName 
having count(distinct status) > 1
) 
then 'Have Multistatus' else Comment end as...

The picture you posted is not a table by definition. It's got duplicate rows! You have no key or constraints. The strings you posted are not how we represent...

I do not consider "2359 to 2359" a valid case, as that might imply it may also span multiple days

As could any of the other midnight-spanning entries. You have...

• This reply was modified 4 years, 11 months ago by kaj. Reason: Color coded quote

Just to expand on the ideas presented by Jeff Moden and Steve Collins, here is my contribution, which also solves the midnight spanning caveat...

(and yes, I prefer a simple select...

....With that, the following creates exactly the output you asked for where none of the above do.

Acknowledged! 🙂

Adapting the code... -- though I'm still assuming that the OP has used...

Instead of manually wrangling with the connection string in SSIS, you'd be better off modifying/overriding the connection attributes using the Expressions on the connection. Hint: you can select the ExcelFilePath...

This code will work for the data provided by the OP. But what if sales does in fact decrease on the last of the month (due to some credit notes...

Thank you, looks promising. Not quite the session scoped lock I was thinking of, but using a transaction scoped lock is probably okay.

But, hmm...

Looking at the description of table hints...

• This reply was modified 5 years, 5 months ago by kaj.

Just as an aside: I like to use Notepad++ instead of the standard Notepad program for checking a text. You can instruct Notepad++ to show all control characters as symbols,...

@cbrammer1219:

This is pure undeluted guesswork, since you haven't provided the requested input and output data samples yet.

I'm imagening a scenario, where products may be unavailable for periods of time (i.e....

Another USe case.

I have multiple parameterized SP for our Application.

When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load...

This is probably a couple of stupid questions that shows my ignorance, but if you never ask how will you learn... 🙂

1. Why are you doing your updates in batches?...

Not to be left out, here's my take on a possible solution: 🙂

DROP TABLE IF EXISTS #testdata;

CREATE TABLE #testdata -- Source data structure as specified by OP...
(
...

Just a thought... have you tried to change the driver on your connection in the package?

If you're using OLE DB, then you're most likely using the old "SQL Server Native...