Merge multiple rows into single row

Hi Arun, please check out bellow URLs



http://mobile.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html


http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query


https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx