Advanced Search

Dimension Check

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. USE
  2. Twizza2009
  3.  
  4. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Ledger Entry Dimension] AS UsedDIM
  5. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  6. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  7. WHERE DimVal.[Dimension Code] IS NULL
  8. GO
  9.  
  10. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Journal Line Dimension] AS UsedDIM
  11. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  12. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  13. WHERE DimVal.[Dimension Code] IS NULL
  14. GO
  15.  
  16. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Document Dimension] AS UsedDIM
  17. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  18. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  19. WHERE DimVal.[Dimension Code] IS NULL
  20. GO
  21.  
  22. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Production Document Dimension] AS UsedDIM
  23. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  24. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  25. WHERE DimVal.[Dimension Code] IS NULL
  26. GO
  27.  
  28. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Posted Document Dimension] AS UsedDIM
  29. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  30. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  31. WHERE DimVal.[Dimension Code] IS NULL
  32. GO
  33.  
  34. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$G_L Budget Dimension] AS UsedDIM
  35. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  36. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  37. WHERE DimVal.[Dimension Code] IS NULL
  38. GO
  39.  
  40. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Service Contract Dimension] AS UsedDIM
  41. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  42. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  43. WHERE DimVal.[Dimension Code] IS NULL
  44. GO
  45.  
  46. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$FA Allocation Dimension] AS UsedDIM
  47. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  48. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  49. WHERE DimVal.[Dimension Code] IS NULL
  50. GO
  51.  
  52. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Item Budget Dimension] AS UsedDIM
  53. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  54. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  55. WHERE DimVal.[Dimension Code] IS NULL
  56. GO
  57.  
  58. SELECT DISTINCT UsedDIM.[Dimension Code], UsedDIM.[Dimension VALUE Code] FROM [Crickley Dairy CC$Document Dimension Archive] AS UsedDIM
  59. LEFT JOIN [Crickley Dairy CC$Dimension VALUE] AS DimVal ON
  60. UsedDIM.[Dimension Code] = DimVal.[Dimension Code] AND UsedDIM.[Dimension VALUE Code] = DimVal.Code
  61. WHERE DimVal.[Dimension Code] IS NULL
  62. GO
  63.  

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.