retrieving data from table

Question

Hi,

        I have small doubt on getting data from table with stored procedure based on parameters from user.i have this table

     

          empno   ename

             1          hari

             2          kumar

             1          pavan

             1          naveen

 

       But want to get data in this way

              empno     ename 

                    1           hari,pavan,naveen

                    2           naveen

     

and also from the user he will pass colname for order by.