SQL Server Performance


Discussion in 'Getting Started' started by rajeshnrh74, Jun 20, 2007.

  1. rajeshnrh74 New Member


    Create table T1 (
    Cl varchar(100),
    Business varchar(100),
    Source varchar(100),
    Analyst varchar(100),
    Times varchar(100))

    insert into T1 values(
    insert into T1 values(

    I've SQL Server 2000 Table like this

    Cl: Business: Source: Analyst: Times:
    GE -- Analytics -- Peer -- Chayan -- Once
    AA -- Collections -- Third -- Remya -- Twice

    I want Output like this

    Cl: Business: Source: Chayan: Remya:
    GE -- Analytics -- Peer -- Once -- Nil
    AA -- Collections -- Third -- Nil -- Twice

    I seek your precious help

    Rajesh N.
  2. Madhivanan Moderator

    Read about Cross-tab Reports in sql server help file


    Failing to plan is Planning to fail

Share This Page