sql PIVOT & UNPIVOT

To get rows fields as columns ...
use pivot queries..
here some code snippets
with urunOzellik
as
(
SELECT U.UrunAd,O.*
FROM tblUrun U JOIN tbEsnekOzellik O
ON O.UrunKod=U.UrunKod
)
SELECT P.*
FROM urunOzellik
PIVOT
(
MAX(deger)
FOR Ozellik IN([TV Out],[Bellek (MB)],[Port],[Güç (W)],[Fan Sayısı])
)
As P


UNPIVOT is used to return rows as the column fields of the query
here are some code snippets...

select UP.*
from tbPivotSatisBilgisi
UNPIVOT (siaprisMiktarı for satislar
IN([2003],[2004],[2005])
)UP