I am new with the stored procedure. 

I have 4 million records so that manually cannot do that so use stored procedure.

I have a table like:

```
Id   Name
-----------------
1    abc
2    xyz
3    abc
4    pqr
5    abc
6    pqr

```

And in that table one filed is called Name. In Name column, some are record are same name so I want to modify records and want like:

```
Id   Name
---------------------
1    abc
2    xyz
3    abc-1
4    pqr
5    abc-2
6    pqr-1

```

& Insert it into another table which have same schema.