I have table of decimal numbers which SUMs give integer numbers:

```
ID  Column1 Column2     Column3 Column4 SUM
1   1247.6  1163.0      1478.6  102.8   3992
2   501.2   203.4       205.1   155.3   1065
3   105.1   257.8       247.7   1025.4  1636
4   247.0   887.4       745.2   476.4   2356

```

When I round these number their sum get change and it usually become SUM +/- 1, It occurs because of rounding.

```
ID  Column1 Column2     Column3 Column4 SUM SUMofRounded
1   1248    1163        1479    103     3992    3993
2   501      203        205     155     1065    1064
3   105      258        248    1025     1636    1636
4   247      887        745     476     2356    2355

```

How can I round these decimal numbers to integers with condition that the SUM stay same. I would prefer solution in SQL Server or VB.NET.

Thanks!