IF OBJECT_ID (N 'TEMPDB for. DBO. # T') IS NOT NULL 
DROP TABLE # T 
GO 

The CREATE TABLE # T 
(ID VARCHAR (10), 
Concrete VARCHAR (20), 
Munber VARCHAR (20), 
GCMC VARCHAR (20), 
WZ VARCHAR (20), 
FS VARCHAR (20), 
Sj datetime, 
FL decimal (18, 2), 
SEQ VARCHAR (20) 
) 

INSERT INTO # T (ID, antonym, Munber, GCMC, WZ, FS, sj, FL, SEQ) 
SELECT '1-1', '00600', 'city tourism', 'bridge column', 'C10', 'pump', '2019-10-02 15:55:05', '90', 'UNION ALL 
SELECT '1-1', '00601', 'city factory', 'see-saw equipment base', 'C30, pump' day ', '2019-10-02 16:05:05', '10', 'UNION ALL 
SELECT '1-1', '00602', 'city factory', 'see-saw equipment base', 'C30, pump' day ', '2019-10-02 17:00:48', '90', 'UNION ALL 
SELECT '1-1', '00603', 'city factory', 'see-saw bottom-board', 'C30, pump' day ', '2019-10-02 19:33:45', '100', 'UNION ALL 
SELECT '1-1', '00604', 'city factory', 'see-saw bottom-board', 'C30, pump' day ', '2019-10-02 20:07:07', '110', 'UNION ALL 
SELECT '1-1', '00605', 'city factory', 'see-saw equipment base', 'C30, pump' day ', '2019-10-02 20:22:20', '190', 'UNION ALL 
SELECT '1-1', '00606', 'glass bridge', 'base', 'C55', 'direct discharge', 'the 2019-10-02 21:00:00', '201', 'UNION ALL 
SELECT '2', '00111', 'glass bridge', 'base', 'C55', 'direct discharge', 'the 2019-10-02 22:00:00', '120', 'UNION ALL 
SELECT '2', '00112', 'glass bridge', 'column', 'C30', 'straight off,' the 2019-10-02 22:30:00 ', '30', 'UNION ALL 
SELECT '2', '00113', 'glass bridge', 'base', 'C55', 'direct discharge', 'the 2019-10-02 23:30:00', '150', 'UNION ALL 
SELECT '2', '00115', 'bridge', 'base', 'C35', 'direct discharge', 'the 2019-10-03 00:30:00', '1', '