File metadata and controls Code Blame 16 lines (14 loc) · 218 Bytes Raw DROP VIEW dbo.V_Chiffre CREATE VIEW dbo.V_Chiffre AS SELECT 0 as 'Chiffre' UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION ...
from CADTransactions T inner join UnitLengths UL on T.ps_UnitLengths_RID = UL.ID inner join Units SU on UL.ob_Units_RID = SU.ID inner join Units TU on T.ps_TargetUnit_RID = TU.ID ...