CREATE TABLE#test(IDINT,VALUE INT,[TIME]DATETIME);INSERT INTO #testSELECT1,11, '2013-07-18 10:00:00'UNION ALLSELECT1,12, '2013-07-18 11:00:00'UNION ALLSELECT1,13, '2013-07-18 12:00:00'UNION ALLSELECT1,14, '2013-07-19 10:00:00'UNION ALLSELECT1,15, '2013-07-19 11:00:00'UNION AL... |