how to Pivot this

• yuvipoy

  SSChampion

  Points: 10469

  More actions

  December 26, 2012 at 11:49 pm

  #268525

  hi

  i am having two tables one table is having header details and another is having data

  Table_idCol_1Col_2 Col_3Col_4 Col_5Col_6

  1Mytab_1_1NULL Mytab_1_2NULL Mytab_1_3 NULL

  Ref_idCol_1 Col_2Col_3 Col_4 Col_5Col_6

  11NULL 2NULL 3NULL

  19NULL 8NULL 4NULL

  14NULL 5NULL 6NULL

  i need to show to client as

  There will be similarity between table1 and table2 which is NULL value.

  Select Mytab_1_1,Mytab_1_2,Mytab_1_3 from table1 which will be header (i have ignored Null values)

  Select *from table2 which is having data

  my output will be something like

  Mytab_1_1,Mytab_1_2,Mytab_1_3 ---header

  1,2,3

  9,8,4

  4,5,6

  Thanks

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  December 27, 2012 at 6:40 am

  #1571847

  From you're DDL, I can't see the FK relationship, so I'm not sure how you're joining your two tables. After you've done that, you can take a look at this: http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx for Pivot examples.

  HTH,

  Rob

• vinu512

  SSCoach

  Points: 15729

  More actions

  December 28, 2012 at 2:10 am

  #1572044

  yuvipoy (12/26/2012)

  ---

  hi

  i am having two tables one table is having header details and another is having data

  Table_idCol_1Col_2 Col_3Col_4 Col_5Col_6

  1Mytab_1_1NULL Mytab_1_2NULL Mytab_1_3 NULL

  Ref_idCol_1 Col_2Col_3 Col_4 Col_5Col_6

  11NULL 2NULL 3NULL

  19NULL 8NULL 4NULL

  14NULL 5NULL 6NULL

  i need to show to client as

  There will be similarity between table1 and table2 which is NULL value.

  Select Mytab_1_1,Mytab_1_2,Mytab_1_3 from table1 which will be header (i have ignored Null values)

  Select *from table2 which is having data

  my output will be something like

  Mytab_1_1,Mytab_1_2,Mytab_1_3 ---header

  1,2,3

  9,8,4

  4,5,6

  Thanks

  With the incomplete/inefficient sample data you have provided, I have a solution which is really easy.....this is how it goes:

  Select Col_1 As MyTab_1, Col_2 As MyTab_2, Col_3 As MyTab_3 From <TableName>

  Please post full information about the requirement, DDL, Sample Data as shown in the link in my signature and you might get a better solution.

  Vinu Vijayan

  For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉