C11/System/ARI/SQL/schema/Kalender/views/kalender.Jahre.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE view [kalender].[Jahre] as
    SELECT DISTINCT (T1.number + 2000) AS "Jahr"
    FROM [master].[dbo].[spt_values] T1,
         [kalender].[Konfiguration] T2
    WHERE (T1.number + 2000) BETWEEN T2.[Jahr_von] AND T2.[Jahr_bis]
      AND T1.[type] = 'P'
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO