Good stuff.  Thank you kindly!

Thank you Eirikur
When you say same order of the composition of the PK, you mean it would be Date (first) and then StoreNumber (second)?  While I was awaiting a...

lol yes...that was a fine way to start the day. Anyway, thanks Steve, I do have some experience with SSIS, but I don't have it set up on my new...

thank you!  Yes, indexes are good and I can return the same info in SQL in less than a second. I'll think about your suggestion t return all the info...