InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:00:29 GMT20http://www.sqlservercentral.com/Forums/Topic1412492-1292-1.aspxI suggestion you make these changes:[code="sql"]SELECT Institution_Number, Attached_Account_Number, [1]=MAX([1]), [2]=MAX([2]), [3]=MAX([3])... (at the end add the following):GROUP BY Institution_Number, Attached_Account_Number[/code]Tue, 29 Jan 2013 02:21:04 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1412492-1292-1.aspxI have a select statement as below:SELECT Institution_Number, Attached_Account_Number, [1], [2], [3]FROM(SELECT CARD_Attached_Acct.Institution_Number, CARD_Attached_Acct.Card_Number, CARD_Attached_Acct.Portfolio, CARD_Attached_Acct.Attached_Account_Type, CARD_Attached_Acct.Attached_Account_Number, Inquiry_Name_To_DDA.Name_ID, Inquiry_Name_To_DDA.Name_LineFROM CARD_Attached_AcctJOIN CARD_Acct ON (CARD_Attached_Acct.Institution_Number = CARD_Acct.Institution_Number) AND (CARD_Attached_Acct.Card_Number = CARD_Acct.Card_Number)JOIN Inquiry_Name_To_Card ON (CARD_Attached_Acct.Institution_Number = Inquiry_Name_To_Card.Institution_Number) AND (CARD_Attached_Acct.Card_Number = Inquiry_Name_To_Card.Account_Number)JOIN Inquiry_Name_To_DDA ON (CARD_Attached_Acct.Institution_Number = Inquiry_Name_To_DDA.Institution_Number) AND (CARD_Attached_Acct.Attached_Account_Number = Inquiry_Name_To_DDA.Account_Number) AND (Inquiry_Name_To_Card.Name_ID = Inquiry_Name_To_DDA.Name_ID)WHERE CARD_Acct.Status_Code = 'A' AND CARD_Attached_Acct.Attached_Account_Type = 1AND CARD_Attached_Acct.Attached_Account_Number = 123) AS SourceTablePIVOT(MAX(Card_Number) FOR Name_Line IN ([1], [2], [3])) AS PivotTableWhen I run the inner Select statement I get results as below:Institution_Number Card_Number Portfolio Attached_Account_Type Attached_Account_Number Name_ID Name_Line02 123456 1 1 123 987 102 456789 1 1 123 654 2My desired result when I run the entire script with the PIVOT is 1 line:Institution_Number Attached_Account_Number 1 2 302 123 123456 456789But what I get is this:Institution_Number Attached_Account_Number 1 2 302 123 123456 NULL NULL02 123 NULL 456789 NULLI'd appreciate any help to get my desired result set! This is frustrating me.:crazy:Mon, 28 Jan 2013 09:09:56 GMTjillk