Further to the request for DDL and an actual execution plan, can you also supply view definitions.

VW_FACT_NLTRANS

VW_DIM_EXPENSECODE

VW_DIM_SUPPLIER

VW_FACT_CURRENCY

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]