on the original query the left outer join was being used

on the 3 queries the OP did trying to solve the issue the left outer join was left as...

Why is this left join used in your "WHERE NOT EXISTS " parts?

           ...

Why is this left join used in your "WHERE NOT EXISTS " parts?

             ...

Well you can be sure it gets created by doing the following

DROP INDEX [dbo].[VIXNearTermExpiration]

Then change your code to do it in two steps rather than one as...

Not sure if this would help but it might be worth a try depending on the amount of data this would generate instead of doing a WHERE NOT EXISTS --...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen. Reason: fixed typos
• This reply was modified 1 year, 7 months ago by  Dennis Jensen. Reason: Fixed a few more typos

Instead of doing it in one massive query, have you considered creating a Temp Table and collecting what you wish to aggregate and then just aggregate what is in that...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen. Reason: fix typos

Yeah I am sure there could be a few ways to alter that SP to a bit more friendly I mean with the OR clause being not an OR clause...

Okay it appears Jeff Moden figured out where the Datetime value was coming from.

Still perhaps this article will help some as you move forward with your project.

• This reply was modified 1 year, 7 months ago by  Dennis Jensen. Reason: Jeff Moden posted a reply just before mine that negated most of my post

If you can share the Stored Procedure in its entirety I can comb through it and see if I notice any issues and/or ways to streamline what you have. If...

• This reply was modified 1 year, 7 months ago by  Dennis Jensen.

In Steve Collins solution the final OR negates all the ANDs which I do not think is what the OP wanted so just in case here is an alternate solution.

Further...

Redoing  noticed something else -- would just delete but do not know how

• This reply was modified 1 year, 7 months ago by  Dennis Jensen.
• This reply was modified 1 year, 7 months ago by  Dennis Jensen.

Ah gotcha Jonathan AC Roberts missed seeing that bit of incongruity

ScottPletcher how is yours different than what Jonathan had already put forth -- they look identical am I missing something?

Okay I am not understanding your comment "I have a feeling it is taking it literally as a string" -- how else should it take it? I mean you are...

I cannot think of any way to facilitate picking apart a SP and running its dynamic parts separately without manually doing something. However, to cover some of the testing I...

I concur with the others' assessements and emphasize that my first go to would be to compare the servers as you have stated the query is the same on DEV,...