Display multiple rows values as single row value (Different Columns)

By acuenca, 2011/10/18

Recently in my work, My boss assigned me the task of creating a schedule of teachers, the schedule can have up to 2 hours of which are in different rows, but should be shown just on one, so I had to make this script.

Recientemente en mi trabajo, me fue asignada la tarea de crear un horario de profesores, dicho horario puede tener hasta 2 horas las cuales van en filas diferentes, pero se deben mostrar en una sola, por lo que tuve que realizar este script.

Total article views: 2771 | Views in the last 30 days: 12

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Display multiple rows values as single row value (Different Columns)

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: