How to juxtapose ( pivot horizontally ) Author names, and group by Book title

• BikeDude

  SSC Journeyman

  Points: 89

  More actions

  January 10, 2015 at 12:52 pm

  #397856

  I have 3 tables - Book, Author, BookAuthorReference

  A book can have multiple authors, and when I do straight query I get multiple rows per book

  SELECT <columns>

  FROM Book b, Author a, BookAuthorReference ba

  where ba.BookId = b.BookId and

  ba.AuthorId = a.AuthorId

  I want to get the results as ONE row per book, and Authors separated by commas, like:

  SQL 2008 internals book Paul Randal, Kimberly Tripp, Jonathan K, Joe Sack...something like this

  :hehe: I

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  January 10, 2015 at 1:32 pm

  #1769253

  http://www.sqlservercentral.com/articles/comma+separated+list/71700/

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)