why are you dropping and recreating the indexes? what are you trying to accomplish with it?

(for Phil - OP has DROP_EXISTING = ON so indexes are there already while...

Are you saying that this proc runs slower in SSIS than it would if you were running it from SSMS?

Have you determined which statement is the slow one (I...

Internet has a...

It would appear that a simple definition of what you want is as follows:

Return the last weekday of the month (regardless of any holidays).

To help others understand...

As you have not provided the logic for your 'business month end' calculation, I'm not sure how you are expecting anyone to calculate it.

EOMONTH() gives you end of month...

maybe this but not guaranteed.

drop table if exists #TEMP1;
drop table if exists #TEMP2;
drop table if exists #TEMP3;

select distinct T1.QUOTE_DATE
into #TEMP1
from dbo.OptionsEOD T1

CREATE CLUSTERED INDEX #CI_TEMP1 ON...

try the following code.

and then give us the actual explain plan for both this code and your code.

drop table if exists #TEMP1;
drop table if exists #TEMP2;

select...

not much you can do about that query (which is the version I gave you) - the nature of the query does not really allow for pre-filtering or use...

no problem

here you...

Did...

no problem

here you go

https://www.brentozar.com/pastetheplan/?id=B1Ons1TUn

thanks for all the replies.  much appreciated.

Some background...I have been making changes to a stored proc.  I made a change (not sure exactly what tho) that resulted in incorrect query...

regarding your last query (from the second plan). two options below

option 1 is just a adjustment of your original query - does same thing but with 1 less join....

can you try this slight variation of my second example and give runtime and plan as well.

drop table if exists #weeklastday;
drop table if exists #temp1;

select distinct...

• This reply was modified 2 years, 10 months ago by water490.

that plan is from you version of the change e.g. where you still keep the dateadd and your temp table does not filter or change the expiration date.

can you...