It is SQL 2000.

I apologize guys. Thank you for being patient. I have updated my Excel with the table def and index info.

I did read the article and it that's how it says to post the execution plan with 2000.

Thanks guys. I attached my execution plan. The table I am trying to query is very large (150 Million rows). There is a clustered index on FKStoreId...

Sorry, I am an idiot. Thanks again for the help!

Thanks for the help! That seems to work except when I get to the second column. Any ideas? Here is what I have.

SELECT @MTD1 = CASE

...