.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

pivoting

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :ASP.Net
 

i am getting following table by union of 4 queries 

 col1     col2 year

1        TD 1982

4         TD 1983

5         TD 1984

3          P1 1983

3          P1 1984

2         P2 1984

 

and i want the result to look like this :

year TD P1 P2 FG

 1982  1 0  0  0

 1983  4 3  0  0

 1984  5 3  2  0

 

Can i pivot my way to it?how?




View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend