Michael Meierruth (1/31/2014)
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?
Hi,
No, the issue with the data is that there are NULL gaps in the 'check in' column all the way through. I haven't seen a contiguous block. It will be running on 2012.
Thanks