@jeffModen  I do not work in Michigan.  I work in California.  So not the same company.  But thats interesting.

@sergiy Thank you so much for your help on updating the query to make creating the view possible. That small change to the where exists made all the...

• This reply was modified 3 years, 11 months ago by  pamkagel.

Thank you Sergy.  I'm still doing some testing but those query changes made a difference so far.

Thank you all for your responses.  I am testing out some of your suggestions.

@jeffModen

1. It currently takes about two hours to load the table.
2. Same database and Database is in...

Tried creating the view.  It was non performant .