Thank you. I tried this but it never gave me a query. It was just saying that it was writing to the partition. I even ran profiler...

Thank you. I meant 500 as $500. It was not the row count. I have double checked the dimensions and fact tables and all the keys are...