I found the answer in the following article:

http://sqlfascination.com/2009/09/30/how-to-remember-the-next-used-filegroup-in-a-partition-scheme

I managed to handle similar issue before by creating an ODBC connection to the SQL Server, create a linked table in MS ACCESS and then create a form based on...

Thanks for the explanation.

Have a good day.

Hi Gila,

Thanks for the wonderful title. It was quite informative.

One related question: is there a way to force the optimizer to use an index in a select statment?

>> 1. How many records are there in the table?

one million

>> 2. Why cant you have only order_total alone .. ?

either way, I got the same result... index is being...