gistfile1.txt

/*Table to modify*/
CREATE TABLE
    dbo.as_i_am
(
    id int PRIMARY KEY IDENTITY,
    some_date datetime,
    some_string varchar(100) DEFAULT 'a'
);

/*Table to capture previous row versions*/
CREATE TABLE
    dbo.as_i_was
(
    id int PRIMARY KEY,
    some_date datetime,
    some_string varchar(100)
);

/*Maple Syrup Data*/
INSERT
    dbo.as_i_am WITH(TABLOCK)
(
    some_date,
    some_string
)
SELECT
    DATEADD(MINUTE, m.n, GETDATE()),
    REPLICATE(CHAR(m.n % 65 + 90), 50)
FROM
(
    SELECT
        n = 
            ROW_NUMBER() OVER
                (ORDER BY @@SPID)
    FROM sys.messages AS m
) AS m;