It seems I can't use old standbys like CTEs and UNION SELECT statements with STAR Schema databases? Is this true or am I missing something? Are there different ways to do this with non-RDBs? They are standard FACT and DIM tables but I need to pull data from the dimension tables to explain the fact tables and nothing seems to work. For information, I am pulling data from Teradata and not using SSMS to write the code as I am still on SQL Server 2005. Thanks!