Randomly merge value of same coloumn in MSSQL :  I have a table of Names and their genders like this,

    +------------+----------+-------+
    | id         | name     | gender|
    +------------+----------+-------+
    |         1  | James    |     M |
    |         2  | Tom      |     M |
    |         3  | Bill     |     M |
    |         4  | Philip   |     M |
    |         5  | Steve    |     M |
    +------------+----------+-------+
And I want this result, 

    +------------+--------------------+
    |     id     | name               |
    +------------+--------------------+
    |         1  | James Steve        |
    |         2  | Tom Philip         |
    |         3  | Steve James        |
    |         4  | Bill Tom           |
    |         5  | Steve Tom          |
    +------------+--------------------+ 

It should pick any random name from the column and merge it with another value from same column. 