SQL server data copy bug? I have one query who shows some data, and those data I'm manually copying to Table1.

The query shows the numeric type and it is in this form 

          Query
    +---------------+
    |    status     |
    +---------------+
    | 1370.00000000 |
    | 2850.00000000 |
    | 426.00000000  |
    | 289.00000000  |
    | 2000.00000000 |
    +---------------+


And when i select it and right click,copy and copy it to other table who is numeric(28,2) it shows the data this way. I have tried changing it to numeric(28,2) but it's almost the same, also decimal type. 

        Table1
+-----------------------+
|        status1        |
+-----------------------+
| 137000000000.00000000 |
| 285000000000.00000000 |
| 42600000000.00000000  |
| 28900000000.00000000  |
| 200000000000.00000000 |
+-----------------------+
Instead of using "Copy-and-paste" to copy from the user-interface; use a T-SQL script to copy the rows from one table to another.

Setup a test-bed with two tables, one will be the source, the other the destination:

USE tempdb;

CREATE TABLE dbo.StatusTable1
(
    StatusNumber NUMERIC(18,10)
);

CREATE TABLE dbo.StatusTable2
(
    StatusNumber NUMERIC(28,2)
);

INSERT INTO dbo.StatusTable1 (StatusNumber)
VALUES (1370.00000000)
    , (2850.00000000)
    , (426.00000000)
    , (289.00000000)
    , (2000.00000000);


this part copies rows from StatusTable1 to StatusTable2:

INSERT INTO dbo.StatusTable2 (StatusNumber)
SELECT st.StatusNumber
FROM dbo.StatusTable1 st;


Show the content of both tables:

SELECT *
FROM dbo.StatusTable1;

SELECT *
FROM dbo.StatusTable2;


Cleanup the test-bed:

DROP TABLE dbo.StatusTable1;
DROP TABLE dbo.StatusTable2;


The results: