sql server mseq: How can I cross-tab the query it was simple in MS-Access but i don't know how
to do it in SQL. the thing i want is as follows:

Simple Query

Item Year Qty
A 1991 10
B 1991 15
C 1991 20

Cross-Tab Query (Items)
ITEMS
Year A B C
1991 10 15 20
--

select year ,
A = (select QTY from tbl t2 where t.year = t2.year and item = 'A') ,
B = (select QTY from tbl t2 where t.year = t2.year and item = 'B') ,
C = (select QTY from tbl t2 where t.year = t2.year and item = 'C')
from tbl t
group by year
order by year

Than u very much dear u were the only who replied my and understand the
issue. But unfortunately u have give the example for static entry I need
dynamic one in the form that whatever records are entered in the table in the
form they autometically comes in this way.
The table name is T_GCombDetail and the fields are:
Comb T3 Per
1 80286 50
1 37395 50
2 80286 100
3 37385 100
4 80286 30
4 37395 70

I need the result in this way after quering
Comb 80286 37395
1 50 50
2 100
3 100
4 30 70

Waiting for your response,
With Regards,


[quoted text, click to view]