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

I don't know that we know that it's Social Security Numbers in clear text, do we? We only know that the name of the column is SSN, I think. It...

This would return NULL if the SSN existed only in the third table (for example). Not what the OP requires, I believe.

Yes, well that's the question, isn't it? I wouldn't...

I shouldnt have a problem joining the tables but my main concern was when i get to the end and write the where filter clause do I have to ask...

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