select COLUMN1, COLUMN2,

sum(case when COLUMN3 =N'P' then COLUMN4 end) as [P],

sum(case when COLUMN3 =N'Q' then COLUMN4 end) as

,

sum(case...

Hi,

There are good articles by Jeff Moden on this subject

http://qa.sqlservercentral.com/articles/T-SQL/63681/[/url]

and second part

http://qa.sqlservercentral.com/articles/cross+tab/65048/[/url]

Kupy

Hi,

As far as I know, the first choice should be the one for 2 reasons

1. The first condition give less records

2. Numeric field is quicker then varchar field

Kupy