SQL Server - Please how can implement the store procedure

HI,

THis is my table :

SNo              AssignTO              Owner           Date
1.            9,5(Users ID)     2              23/3/2013
2.           3,7            2                23/3/2013


now i make it as


Sno           Assign To                                       owner        Date
1.           Rahul, Madhu(User Name)            abc        23/3/2013

2           kirthi, rath(Details will come from Login tables)  abc   23/3/2013

please help me

This makes no sense