How to merge & center duplicate values in SQL Server 2008

See more:

SQL-Server-2008R2

, +

Hi All, I want to know is there any way, to remove duplicate values from resultset and merge that columns. Let me clarify by showing query and resultsets.

SELECT DENSE_RANK() OVER (ORDER BY EmpID) AS [SrNo], EmpID, EmpName,
Location, Department, CONVERT(varchar(10), AttDate, 103) AS AttDate, TimeIn, TimeOut, AttStatus
FROM tbl_Att

SrNo    EmpID   EmpName Location    Department  AttDate TimeIn  TimeOut AttStatus
1       T001    TestEmp1    Mumbai  Admin   12/9/2015   0:00:00 16:30:00    AB
1       T001    TestEmp1    Mumbai  Admin   13/09/2015  8:00:00 00:00:00    AB
2       T002    TestEmp2    Mumbai  Admin   12/9/2015   9:00:00 18:30:00    PR
2       T002    TestEmp2    Mumbai  Admin   13/09/2015  9:30:00 18:30:00    PR
2       T002    TestEmp2    Mumbai  Admin   14/09/2015  9:30:00 18:30:00    PR
2       T002    TestEmp2    Mumbai  Admin   15/09/2015  9:30:00 18:30:00    PR
3       T003    TestEmp3    Mumbai  Admin   15/09/2015  9:00:00 20:30:00    PR

I want to display output like this :-

SrNo    EmpID   EmpName Location    Department  AttDate TimeIn  TimeOut AttStatus
1       T001    TestEmp1    Mumbai  Admin   12/9/2015   0:00:00 16:30:00    AB
                                            13/09/2015  8:00:00 0:00:00     AB
2       T002    TestEmp2    Mumbai  Admin   12/9/2015   9:00:00 18:30:00    PR
                                            13/09/2015  9:30:00 18:30:00    PR
                                            14/09/2015  9:30:00 18:30:00    PR
                                            15/09/2015  9:30:00 18:30:00    PR
3       T003    TestEmp3    Mumbai  Admin   15/09/2015  9:00:00 20:30:00    PR

Will it be possible through SQL Query???
Please help.