Pivot View

[Tauseef A]

hi guy i have pretty simple requirement i have three rows in my table year ----amount 2011-----100 2012-----200 2013------400 now what i want is to show these rows in columns lets say as i have three distinct years so i want to create three columns ar run time and these columns should be 2011--------2012----------2013 100--------200------------400 any ideae how to achieve this? is this a pivot view ? regard. Tauseef A Khan MCP Dotnet framework 2.0.

[DaveAuld]

Yes it is a PIVOT, you can do this directly from a SQL Query http://msdn.microsoft.com/en-us/library/ms177410.aspx[^]

Dave Find Me On: Web|Facebook|Twitter|LinkedIn

---

Folding Stats: Team CodeProject