cross tab...
Vasanthakumar D replied to Prakasam J at 09-May-08 03:20

Hi,

you need to create cross tabs for this..

check here

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

http://www.dotnetjunkies.com/WebLog/thomasswilliams/archive/2005/10/23/133383.aspx


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  How to show resulting records columnwise in sqlsever 2000 - Prakasam J  09-May-08 02:59 2:59:14 AM
      cross tab... - Vasanthakumar D  09-May-08 03:20 3:20:28 AM
      queries - sundar k  09-May-08 03:39 3:39:51 AM
View Posts

promotion
Silverlight    WPF    WCF    WWF    LINQ   
JavaScript    AJAX    ASP.NET    XAML   
C#    VB.NET    VB 6.0    GDI+    IIS    XML   
.NET Generics    Anonymous Methods    Delegate   
Visual Studio .NET    Expression Blend    Virus   
Windows Vista    Windows XP    Windows Update   
Windows 2003 Server    Windows 2008 Server   
SQL Server    Microsoft Excel    Microsoft Word   
SharePoint    BizTalk    Virtual Earth   
.NET Compact Framework    Web Service   


"Everything" RSS / ATOM Feed Parser
How to send and receive messages through message queuing in .Net
How to Read text file as database
SQL Server 2005 Paging Performance Tip
Display code of web page.
Fully Scalable Excel File Importer class for .net using Microsoft Jet driver
Generic Chart Color Manager class that can be used for any charts
Helper class to style the infragistics wingrid
Using Reflection to detemine as Assembly Info in and out.
Helper class to play with Window (Owners and position)
Resolving displayname from the culture using the XmlLanguage and LanguageSpecificStringDictionary class