Row to Column - Phone Numbers

• dixons

  SSC Rookie

  Points: 43

  More actions

  March 21, 2011 at 9:27 am

  #157492

  I am trying to do a query that is way over my head. I am trying to get phone numbers for student contacts. Each student may have 1-8 contacts with different phone numbers.

  StudentID ContactType PhoneNumber

  1 Emergency Contact 6301234567

  2 Father 6301234567

• WayneS

  SSC Guru

  Points: 95461

  More actions

  March 21, 2011 at 10:05 am

  #1301389

  See the two articles referenced in my signature dealing with Cross-Tabs and Pivots - Parts 1 and 2.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2