Thank you very much for the advice. This table and many others like it in this database were inherited. I will restructure this table and try to build...

I did that, and it did improve it some. Where you speeking of a single index or a combined index with the two columns?

Ok, I'm going to try indexing the Period column. This table has 211k records in it through June, with July & Aug that would bring it to about 350k....

Ok, I figured out what was wrong with this for anyone readers that might be interested.

First of all, the data file that I received was from Excel and had the...

Thanks for that logic!:-D

I was thinking the exact same thing, but I guess I was making it more complicated than it had to be because of the way the With...

How would I accomplish this with a variable in my criteria such as @AdjustmentId? I could see the view working without this, but can't figure out how to make...

Having some difficulty figuring out how to address the alias portion of your answer. For example

In my problem I have:

Select i.field1, i.field2, i.field3

From

...

Oh, OK. I understand by looking at your code. Thank you so much for your help with this.

It was very helpful!:-D

That is very helpful! Thank you.

I didn't realize I could get multi-table datasets returned from a stored proc.

😀

Possibly you didn't install all of the components of VB Studio when you did the install? I looked in my new project install templates view and it is there....

Really?!

Ok, I'll have to take that under advisement when designing an update to the interface.

Thanks again for you insight.

Thank you so much for imparting your knowledge on me regarding this! I really appreciate it.

So I can create my id's using this algorithm as well.

😀

Thanks,

Greg

Thank you so much. I see that I need to open a new Query window. That worked great! Thanks