CrossTab

[rajeshnrh74]

Gurus,

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.

 

[rajeshnrh74]

For your convenience

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

insert into T1 values(
'GE','Analytics','Peer','Chayan','Once')
insert into T1 values(
'AA','Collections','Third','Remya','Twice')


Rajesh N.

 

[sunila7]

Search for Cross Tab in this forum there are a lot of questions on Cross Tab queries. Here is a thread that discusses the issue.

thread183-1068258

Sunil