Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Type 2 SCD without merge RE: Type 2 SCD without merge

  • December 1, 2015 at 12:34 pm

    #1843313

    something like this is what i slapped together; does this look right?

    UPDATE MyTarget

    SET

    MyTarget.[IsCurrent] =0,

    MyTarget.[ValidToDate] = getdate()

    FROM [StagingDataDump] MySource

    INNER JOIN [DataDump] MyTarget

    ON MySource.[PK] = MyTarget.[PK]

    AND MySource.[Col2] = MyTarget.[Col2]

    INSERT INTO [DataDump](ColumnList,IsCurrent,ValidFromDate,ValidToDate)

    SELECT MySource .ColumnList,1 AS IsCurrent,getdate() AS ValidFromDate, '12/31/2999' AS ValidToDate

    FROM [StagingDataDump] MySource

    INNER JOIN [DataDump] MyTarget

    ON MySource.[PK] = MyTarget.[PK]

    AND MySource.[Col2] = MyTarget.[Col2]

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!