|
|
CREATE TABLE tab(NR VARCHAR(100), GRD VARCHAR(100), DT DATE);
INSERT INTO tab
SELECT '00000000000000000001' AS NR, N'06' AS GRD, DATE '2013-01-01' AS DT UNION ALL
SELECT '00000000000000000001' ,N'06', DATE '2013-01-01' UNION ALL
SELECT '00000000000000000001' ,N'21', DATE '2013-01-01' UNION ALL
SELECT '00000000000000000002' ,N'06', DATE '2013-01-01' UNION ALL
SELECT '00000000000000000002' ,N'21', DATE '2013-01-01' UNION ALL
SELECT '00000000000000000004' ,N'01', DATE '2013-03-31';
|
