Skip to content

Instantly share code, notes, and snippets.

@ThomasFalkner

ThomasFalkner/ExampleMonthDiff.sql

Created September 13, 2023 09:27
Download ZIP

Revisions

  1. ThomasFalkner created this gist Sep 13, 2023.
    20 changes: 20 additions & 0 deletions ExampleMonthDiff.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    DECLARE @ReferenzDatum AS DATE = '31.01.2023';
    DECLARE @Datum AS DATE = @ReferenzDatum;
    DECLARE @i AS INT = 0;
    IF OBJECT_ID('tempdb.dbo.#Datumsbereich', 'U') IS NOT NULL
    DROP TABLE #Datumsbereich;
    CREATE TABLE #Datumsbereich(
    DatumZahlung Date,
    Datum Date,
    DifferenzMonate int
    )
    WHILE @DATUM <= CONVERT(DATE,GETDATE())
    BEGIN
    INSERT INTO #Datumsbereich (DatumZahlung, Datum, DifferenzMonate) VALUES (@ReferenzDatum, @Datum, DATEDIFF(m, @ReferenzDatum,@Datum))
    SET @Datum = DATEADD(d,1,@Datum)
    END
    SELECT FORMAT(DatumZahlung,'d','de-de') AS DatumZahlung
    ,FORMAT(Datum,'d','de-de') AS Datum
    ,DifferenzMonate
    FROM #Datumsbereich