Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to Pivot this Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2012 11:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 5:57 AM
Points: 332, Visits: 1,120
hi
i am having two tables one table is having header details and another is having data

Table_id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 Mytab_1_1 NULL Mytab_1_2 NULL Mytab_1_3 NULL


Ref_id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 1 NULL 2 NULL 3 NULL
1 9 NULL 8 NULL 4 NULL
1 4 NULL 5 NULL 6 NULL

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
Post #1400479
Posted Thursday, December 27, 2012 6:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 1,163, Visits: 1,187
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
Post #1400599
Posted Friday, December 28, 2012 2:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:48 AM
Points: 1,118, Visits: 1,582
yuvipoy (12/26/2012)
hi
i am having two tables one table is having header details and another is having data

Table_id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 Mytab_1_1 NULL Mytab_1_2 NULL Mytab_1_3 NULL


Ref_id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 1 NULL 2 NULL 3 NULL
1 9 NULL 8 NULL 4 NULL
1 4 NULL 5 NULL 6 NULL

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
Post #1400833
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse