• sqldriver,

    Could your data also contain a sequence like the following, i.e. cgm changes without one or more rows having cgm null in between:

    ('1', '2012-01-01 07:05', '5'),

    ('1', '2012-01-01 07:06', '5'),

    ('1', '2012-01-01 07:07', '5'),

    ('2', '2013-05-02 07:10', '24'),

    ('2', '2013-05-02 07:20', '24'),

    ('2', '2013-05-02 07:30', '24')

    Could there be gaps in the ctime values (as shown above)?

    What version of SQL Server must this run under?