USE
Twizza2009

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Ledger Entry Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Journal Line Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Document Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Production Document Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Posted Document Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$G_L Budget Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Service Contract Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$FA Allocation Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Item Budget Dimension] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Select Distinct UsedDIM.[Dimension Code], UsedDIM.[Dimension Value Code] from [Crickley Dairy CC$Document Dimension Archive] as UsedDIM
Left Join [Crickley Dairy CC$Dimension Value] as DimVal ON
UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension Value Code] = DimVal.Code
Where DimVal.[Dimension Code] IS NULL
GO

Dimension Check

SQL