Select Query Question

• Hags61

  Newbie

  Points: 3

  More actions

  July 25, 2007 at 2:04 pm

  #179849

  I have two tables with a 0-to-many relationship.  Contract (ContractID, ....) and CustRelationship (ContractID, CustID, CustPercent).  CustRelationship has multiple rows that point back at Contract.  Is it possible to get all the CustID's into a single row for each Contract?

  Example:

  ContractID	CustID	CustPercent
  1234	12	50.00
  1234	54	25.00
  1234	74	25.00
  ...	...	...

  Output
  1234	12	54	74
  ...	...	...	...

  Thanks.

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  July 25, 2007 at 2:16 pm

  #722421

  Yes. It is called PIVOT or CROSSTAB queries.

  There are examples of this in Books Online.

  Or have a look at

  http://www.sqlservercentral.com/columnists/plarsson/pivottableformicrosoftsqlserver.asp

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"